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...
I started getting involved in discussions after this new appeal on the website ..It looks like a real PORTAL. Love to view all posts since i last last logged.
Great Job and would love to contribute if the team needs.
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 ...
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 ...
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...
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...
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...
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.
Please post the issue with complete description. This would help people on the threads answer it ASAP and keep the discussion within the scope of thread.
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...