Search found 4 matches

by kkumar@frk.com
Mon Apr 24, 2006 8:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple Rows Retreival from - something similar to hash
Replies: 6
Views: 1765

Re: Multiple Rows Retreival from - something similar to hash

Hello I have a situation where I am getting one record from source that needs to create multiple rows in the target. I am attempting to do this using with an implicite cartesian. The number of rows I need to create is determined by an output from a Oracle OCI to a hash file. (the reason I am doing ...
by kkumar@frk.com
Sat Apr 22, 2006 5:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple Rows Retreival from - something similar to hash
Replies: 6
Views: 1765

The business requirement is to spread cost incurred for maintaining an application (telecom, network cost etc.) across all other APPLICATIONS prorated. Eg: Telecomm Cost 10000 Application 1 Maintenance Cost (SAP) - 800 Application 2 Maintenance Cost (PeopleSoft) - 600 Application 3 Maintenance Cost ...
by kkumar@frk.com
Sat Apr 22, 2006 5:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple Rows Retreival from - something similar to hash
Replies: 6
Views: 1765

Yes will take a stab at using merge and let you know how it goes. Thanks for the quick response
by kkumar@frk.com
Sat Apr 22, 2006 1:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multiple Rows Retreival from - something similar to hash
Replies: 6
Views: 1765

Multiple Rows Retreival from - something similar to hash

Hello I have a situation where I am getting one record from source that needs to create multiple rows in the target. I am attempting to do this using with an implicite cartesian. The number of rows I need to create is determined by an output from a Oracle OCI to a hash file. (the reason I am doing t...