Search found 2 matches

by amritendra
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 ...
by amritendra
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 ...