Thanks Shaan,
That worked.
Search found 72 matches
- Fri May 13, 2005 12:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting the Looked up Data
- Replies: 7
- Views: 2224
- Thu May 12, 2005 11:13 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read Parameter Frmo a Parameter File
- Replies: 11
- Views: 7056
There is One way which we follow. 1. We call the Datasatge Jobs within the unix script . 2. As videsh suggested we use parameter.profile to set all the parameters except for the Passwords. 3 . Then using these parameters we get the Password from one of Server Wide script say get_pass. ex. we get the...
- Thu May 12, 2005 7:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting the Looked up Data
- Replies: 7
- Views: 2224
- Thu May 12, 2005 5:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting the Looked up Data
- Replies: 7
- Views: 2224
Getting the Looked up Data
Hi, I have a Job design in which source data is looked up against the data in the hash. The Requirement needs both the source records and matching record(based on key lookup) in the Target file. The Design which i built and is working fine is SRC---filter bycond a--->XFM1----->XFM2 using Lookup-----...
- Thu May 05, 2005 5:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Replicating input rows based on condition
- Replies: 1
- Views: 938
Replicating input rows based on condition
Hi , I am designing a job which requires , that for each record of source it will replicate the source record N times depending on some condition(ex.N=Number of matching Records found in Hash). Desgin i used is Src-----| |----------------Transform---------->Target Hash---| I tried with @outrownum .b...
- Thu May 05, 2005 4:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Catesian Product Of Sequential files
- Replies: 15
- Views: 9052
- Wed May 04, 2005 5:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Catesian Product Of Sequential files
- Replies: 15
- Views: 9052
Hi, I used Merger stage as suggested using a dummy column and tried with complete set and inner join.But i was not able to get the desired result. File Src1 Column list----->a b dummmy 1 2 Z 3 4 Z 5 6 Z File Src2 Column list------->d e Dummy 11 12 Z 13 14 Z 15 16 Z The OUptut was a b d e Dummy Dummy...
- Tue May 03, 2005 3:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Catesian Product Of Sequential files
- Replies: 15
- Views: 9052
- Mon May 02, 2005 8:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Catesian Product Of Sequential files
- Replies: 15
- Views: 9052
Catesian Product Of Sequential files
Hi, Our business Requirement states that we need to create cartesian product of 2 Sequentials files for loading. For Example, File Src1 Contains Coulmn Names--> a b c 1 2 3 4 5 6 File Src2 Contains Columns names ---->d e f 11 12 13 14 15 16 Then the output file shld contains Column Names a b c d e f...
- Mon Apr 04, 2005 12:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Control Loading of the Target table
- Replies: 2
- Views: 1191
Re: Control Loading of the Target table
Thanks Roy, Hi, In our Project we want to implement Control Loading,Logic as follows. 1> Divide the total rows in the staging table by n(constant) adn obtain n ranges(group of rows). 2> Then Load each of range seperatley in the target table. 3> If any of the row in the ranges fails ,the entire range...
- Fri Apr 01, 2005 3:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Control Loading of the Target table
- Replies: 2
- Views: 1191
Control Loading of the Target table
Hi, In our Project we want to implement Control Loading,Logic as follows. 1> Divide the total rows in the staging table by n(constant) adn obtain n ranges(group of rows). 2> Then Load each of range seperatley in the target table. 3> If any of the row in the ranges fails ,the entire range is rollback...
- Fri Apr 01, 2005 3:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Control Loading of the Target table
- Replies: 1
- Views: 1094
Control Loading of the Target table
Hi, In our Project we want to implement Control Loading,Logic as follows. 1> Divide the total rows in the staging table by n(constant) adn obtain n ranges(group of rows). 2> Then Load each of range seperatley in the target table. 3> If any of the row in the ranges fails ,the entire range is rollback...