DSXchange

U can use the same job and have Multiple Instance of the Job and pass the Parameter for the same. U can open the Job and you have Job Parameter,in that u have a check box for Muliple Instance and then use the same Job and Pass the PARAMETER for which ever Year is needed. I hope this will solve ur pr...

All, Thank you very much for all your responses. :wink: Mahesh, Your most recent round of questions suggests that you are in need of the DataStage Essentlals class (DS314Svr or DS314PX). As a general rule the Sequential File stage is the fastest for writing. Using the DB2 bulk loader stage, though, ...

Hi, Thnxs for ur timely help!!. I have the following questions! What is the performance issue, When I directly load data into the UDB database and when I use a Seuential Stage to get the outputed data and then use the UDB Bulk load Stage to load the data? How to improve the performance of an ETL Job...

Hi Ray, Thanks for all of your comments! I am using Before Routine to Concatenate the Files but the problem is its giving me an error message as follows *********** UDBBulkLoadJob..BeforeJob (ExecSH): Error when executing command: Cat Stage_Party_Varchar.txt Stage_Party_Integer.txt Stage_Party_Date....

Hi, I have the following questions:- 1. Currently I am doing a Performance Testing in a Job which inserts data into the UDB DB2 Stage serially as well as parallelly.The Question is When I load data serially the performance is faster but when I use the parallel laoding the performance slow compared t...

Thnxs for the information. If I need to use the Rotuine,Please let me know where to include this "Before Job Subroutine" Thnxs again. DataStage has a Merge stage that lets you merge two files together. It is useful when you have two files with different formats that can be merged into the ...

Hi All, I am new to Data Stage. I have a question regarding File Stage, I have 6 different files of same structure.I need to concatenate the 6 files into one single file and pass it on to the UDB Bulk load stage. In Unix I can use the Cat command, but in Data Stage how do i do it :?: Please let me k...