Search found 7 matches

by ceenu
Thu Feb 16, 2006 5:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Inserting the row
Replies: 2
Views: 1590

Inserting the row

Hi : I have Price table and item table. For that i have a two jobs. Whenever price is changes occur in first job for the same id,it will go and insert for the History purpose. Same way to the Item table (second job) for that perticular priceid insert the another recoed for History purpose.For this i...
by ceenu
Thu Feb 02, 2006 12:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup with duplicate values in key column
Replies: 14
Views: 5579

Re: lookup with duplicate values in key column

Thanks,sorry about posting in parallel.
You mean it will pickup only first record

thanks
ceenu
by ceenu
Thu Feb 02, 2006 11:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup with duplicate values in key column
Replies: 14
Views: 5579

Re: lookup with duplicate values in key column

Hi All,

Couple of clients asking Same question in the interview in case of Hashfile stage.
Please let me know it will load all duplicates or only first record.

Thanks
ceenu
by ceenu
Sat Jan 28, 2006 5:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Command line commands for datastage
Replies: 7
Views: 5507

Re: Command line commands for datastage

we sould enter to datastage through windows only.

Thanks
Ceenu
by ceenu
Sat Jan 28, 2006 5:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Command line commands for datastage
Replies: 7
Views: 5507

Re: Command line commands for datastage

we sould enter to datastage through windows only.

Thanks
Ceenu
by ceenu
Sat Jan 28, 2006 3:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Update access to the target database
Replies: 3
Views: 2276

Re: Update access to the target database

Hi,

If you would need UPDATE privilege to perform insert,update and delete in the database as an interactive user, then you will need it to perform the same tasks as a DataStage user.

Thanks
Cnu[/url][/b]
by ceenu
Sat Jan 28, 2006 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of stage - Hash files
Replies: 7
Views: 2621

Re: Abnormal termination of stage - Hash files

Hi,

While you are using a large data Aggregator stage gives error due to the method option. Change the method option in the Aggreator stage to the SORT.
If you possible give us the exact error are you getting.

Thanks
cnu