DSXchange

Hi, I have this sample Data,

Col A Ref_No
0275 0217
0217 0456
0456 0000

How to assign same surrogate key to all of them, since all of them are in link.

0456 is the base number and all base number having Ref_No=0000

Any suggestions will be most welcome.

Thnks.

Hi All,

I have to create an output file with ODO clause but I am not able to find the right way to do this in DataStage.

Thanks
Ashish

Sainath.Srinivasan wrote:What have you tried so far and what were your problems ?

Is the provided example the full record or only the occurs clause section ?

Not full record just the section

Hi All,

I have scenario and I am trying to accomplish by using ODO clause in Target CCF stage but its not wrking ?

Input Scenario :
Key | Col1 | Col2 | Col3
1 | X | Y | Z
1 | X | Y | Z
2 | A | B |C

Ouput :
1 |X|Y|Z|X|Y|Z
2 |A|B|C

One question ray -- if DB2 stage operation "update or insert" run in parallel mode doest it impact the data?

Thanks
Ashish

Hi All,

Db2 UDB stage which is running on 1 node and Sequential performing a operation "insert new or update existing one" taking 20 to 25 minutes for
70000 records, can any onle help me to tune the performance.

Thanks
A

Is hash parition required before join in parallel job? when Config file is of 1 node. I am looking into a job design in which before join, sort stage is been used and in sort stage hash partition in used and in join stage same partition is been used. Is really a hashing reuiqred in sort stage prior ...

Hi DS Gurus, I would like your suggestion in designing a parallel job. Job Design is Input of transformer is Seq. file and output is 2 links which again input to the Same database table. 1st link containing only New-Inserts records for Table X 2nd link containing Insert-Updates records for Table X I...

DateFromDaysSince(-1, stringtodate(right(0:MonthFromDate(CurrentDate()),2):'-':'01':'-': YearFromDate(CurrentDate()),"%mm-%dd-%yyyy")) in datastage this should work fine. this first derives the 1st day of current month and then subtracts 1 day from that. in oracle sainaths code works fine...

Hi,

How to get the last date of the previous month.?

Thanks
Ashish

No Ray we can't add RDUP stage on right side,

I got 2 files from source Structure of File1 is Col1 Col2 Col3 1 RS A 1 RD B 1 GD C Structure of File2 is Col1 Col5 1 TB 1 TB By using above two files I have to create output file like Output file structure Col1 Col2 Col3 Col5 1 RS A TB 1 RD B TB 1 GD C Can any one help me how to create output file ...

Thanks for the solution :)

Yes, src file got 3000 records but I want to create 1000 record file but i don't want to hard code the values for NR, i wanted to pass it through paraemeter only.

Return code is 0 which means script ran fine
out is blank