Thanks Ken. Infact i was trying with a sample of the way that you had suggested. It works !!!
Thank you all for the responses.
Search found 19 matches
- Wed Nov 19, 2003 9:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup - No of Rows returned
- Replies: 14
- Views: 7601
- Wed Nov 19, 2003 8:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup - No of Rows returned
- Replies: 14
- Views: 7601
Thankyou all for the reply to the post. Heres what i want to do. I have col1 and col2. Now the scenario of data could be col1 col2 1234 NULL 1234 9999 2345 NULL 3456 8888 3456 NULL 6789 NULL Now what i would like to do is when i lookup, I would like these values to be returned. 1234 9999 2345 NULL 3...
- Tue Nov 18, 2003 10:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup - No of Rows returned
- Replies: 14
- Views: 7601
Lookup - No of Rows returned
Hi,
Can anyone let me know if i would be able to figure out if the number of rows returned by a lookup is more than one ?
Regards
Rahul
Can anyone let me know if i would be able to figure out if the number of rows returned by a lookup is more than one ?
Regards
Rahul
- Fri Nov 14, 2003 3:06 pm
- Forum: Site/Forum
- Topic: What do you think of the DSXchange so far?
- Replies: 11
- Views: 7998
- Fri Nov 14, 2003 8:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LOG WITH THE NAME OF THE COLUMN ...
- Replies: 3
- Views: 3399
If you know what the condition is that would reject the record then use the constraint rather than default reject. When you use a constraint you can trap (know) the column that is causing the reject and assign this to a stage variable and get this passed over as a derivation. If anyone has a better ...
- Fri Nov 14, 2003 8:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Partitioner/Collector Performance
- Replies: 5
- Views: 2746
- Thu Nov 13, 2003 1:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Partitioner/Collector Performance
- Replies: 5
- Views: 2746
I have set the target as flatfile. If i do a simple test with no partitioner/collecotor links,the performance is far better. seq->xfm->seq On this i recieve consistently around 5000 rows/sec. But same thing if done with link partitioner/collector then it becomes slow. I had carried this out to show ...
- Thu Nov 13, 2003 11:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Partitioner/Collector Performance
- Replies: 5
- Views: 2746
Partitioner/Collector Performance
I am just trying to a performance test on extracting data from flatfile and loading into another flatfile with/without partitioner and collector. Seq->partitioner->xfm----->collector--->seq | | ->xfm---------> I have enabled interprocess buffer to its default. What i observe is that when the process...
- Thu Nov 13, 2003 8:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: RTS experiences?
- Replies: 2
- Views: 1627
This is a very good topic and i hope people would pour in more on what they have experienced so far on RTI. Has anybody worked on applications integrating MQSeries/EJB with DS. If yes, Can you please let us know what the architecture has been,functionality and what were the benefits out of the new a...
- Tue Nov 11, 2003 9:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Accessing Excel Sheet with ODBC
- Replies: 6
- Views: 4357
Thanks Steve,Gunnif and everybody for the posts. Steve, I would like things to do the perl way when we do not have any options left. CPAN has modules for nearly everything. :D But folks are hesitant on putting the ExcelParser on. They would like to stick onto the traditional way of converting the fi...
- Mon Nov 10, 2003 2:11 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Accessing Excel Sheet with ODBC
- Replies: 6
- Views: 4357
- Mon Nov 10, 2003 2:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Accessing Excel Sheet with ODBC
- Replies: 6
- Views: 4357
Accessing Excel Sheet with ODBC
Hi All,
Can somebody give me a small jist of the changes that needs to be done to odbc.ini and uvodbc.cfg for ODBC access. I have excel file as the source. These files are ftp'ed into the unix environment and datastage should work on these excel files placed on unix box.
Thanks
Rahul
Can somebody give me a small jist of the changes that needs to be done to odbc.ini and uvodbc.cfg for ODBC access. I have excel file as the source. These files are ftp'ed into the unix environment and datastage should work on these excel files placed on unix box.
Thanks
Rahul
- Mon Nov 10, 2003 11:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Interesting issue
- Replies: 22
- Views: 7156
- Fri Nov 07, 2003 12:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error calling DSR_EXECJOB
- Replies: 3
- Views: 1848
- Fri Nov 07, 2003 10:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Interesting issue
- Replies: 22
- Views: 7156
Why do you do all these ? Heres a simple trick. Let your source process create a control file/ Indicator file as soon the data is written completely to the datafile. Let your process keep looking for the control/indicator file and once this file appears, it implies that data has been completely writ...