DSXchange

ray.wurlod wrote:I guess you need a Promote Subrecord stage in there. ...

Hi ,

I was trying to use promote subrecord stage but in properties iam able to specify only one parent column...but iam two parent columns...

Any ideas...

But Ray is it possible to copy data from this format to other target...

when iam trying to copy data from dataset to seq file...its giving following error..

input first is not value field....

Thanks...

ray.wurlod wrote:This is the correct format. The braces are added by the data browser; they are not actually part of the data, but are indicated by the metadata (record schema) in which subrecord is indicated. ...

Thank you ray...

Hi All, Iam using compare stage and for output i enabled RCP and defined 3 cols.. diff(tinyint) first(unknown) second(unknown) Iam getting proper output but problem is iam getting like below format.. diff first second -1 (1,aaa,bbb) (3,aaa,bbb) Iam getting subrecords in braces..Is this correct forma...

Hi All,

Does XML file have default XSD file....I mean i used sample xml file in my job with out defining xsd file...I imported metadata from that sample xml file itself and worked using in xml stages....

If default xsd is defined by default where can we see it??

Thanks

Thanks chullet,

So we should pre create target table (in my case join table) in database ..right?

And is fasttrack tool available in 7.x version??

Ray,

Iam not developing job in designer...Iam trying to create job using information server fast track...(job design is to join two tables)

Can we use seq /flat files as sources and targets in Fast track?....

Thanks for reply...

Hi All, I was trying to generate job by fast track..The idea is to join two tables in fast track... My doubt is i dont have a target join table in database ..does fast track supports sequential file to store the join result? And if doesnt support should we have a target table already present in data...

Hi Ray, I tried using what you've suggested me..but not getting the result.. What i understood is "preload file to memory" , if it is set the lookup is done from memory and if record id not found lookup is done in file... By doing this if iam getting a record which is updated twice before ...

Hi Ray,

Thanks for reply,

I edited my job ...give me suggestion in solving...

thank you

Hi All, Iam trying to implement SCD2 in server job... ODBC(Dim table)------->Transformer-------->SEQ(capturingupdates) | | hash file | | ODBC(source / reference) If any record got updated from reference , a new record of same key is created with updated values which is basically SCD2.. My doubt is i...

More information on below link..


http://home.iprimus.com.au/raywurlod/un ... naries.htm

Thanks chullet for your response..

And ill post in proper from next time....

Thanks chullet for your reply, So, If data is huge , around million records its is efficient to use hash file stage to store data before further processing.. Have another question Q.Hash files stores non key values as dynamic arrays....I want to know how key values are mapped to non key values...lik...

Hi All, Iam a new Bie to Datastage...Firstly this forum is very use full for learning and thanks for Everyone contributing for helping to learn and solve issues... I have a doubt regarding Speed and efficiency in identifying a record(for huge number of records say for example 10,000)... 1.Creating i...