Search found 2 matches
- Mon Apr 06, 2009 12:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: diff b/w merge and join
- Replies: 7
- Views: 3890
Re: diff b/w merge and join
hi , i have an one reqirement to join 5 tables based on a same field,i have to use 5 different oracle stages and one join stage in these tables the main table having around 1.5lac records remaining tables having more than 4 lac ,i tried with joiner stage as left outer join where main table is left ...
- Mon Mar 23, 2009 11:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequence generated in DB2
- Replies: 8
- Views: 3293
Re: Sequence generated in DB2
Hi, I have generated a Sequence in DB2. How can i import or use it in Datastage? I want to use it as a key generator in my Job. Hi In target DB2 stage You can use option user defiened update and insert . Then you can assign value like below. INSERT INTO schema name .Table name ( Key field ) VALUES ...