DSXchange

I have a requirement to create a job which can handle 3 different files, each one of them has different metadata and writes the data to Oracle tables?

Any help on this is highly appreciated.

Hello, I am trying to complie a server job which has RUNJOB command in a transformer stage. When I complie it, I get an error message that "Variable Runjob not found". This same job works fine in other environment where I export/imported it from. Can someone help me resolve the issue? Than...

Hi, How can dynamic lookup be implemented in Datastage in a single job? I mean if there are 2 records in the source file/dataset which is looked up on a table and one inserted to table (same table as it was looked up on) as it is new (or the first one) and will the second record be updated to the ta...

Thanks Chulett, it was useful.

Hi,

How do I find/look for a particular object in datastage jobs- eg., how can find the list of jobs that uses a table called EMP or a file called EMP.txt?

Please help me find this- this will help me avoid opening all the 200 datstage jobs we have in our project.

Thanks,
Vij

hi,

thanks for the quick response, I appreciate it.

As per your example, there are 2 columns - EMPLOYEE_NO and DEPT_ID. But in my case, I have only the account number column and need to maintain the sort order as I receive from the UNIX file.

Is it possible?

Thanks again,
vij

Hi, I have a question regarding the order of records in a file and how the order is handled by ETL. I have a ETL job which uses a file as source and the job has to remove duplicate based on the account number column and retain the last record. Records which have the same account number carry differe...

Is it possible to get this from dsjob command? and also I am not sure if I am in the correct path in unix to execute the dsjob command.

I tried the dsjob -logsum command, but I got the below error message:

ksh: dsjob: not found

Hi, I would like to find out the list of datastage jobs that run before 6 months from the current date. I can hardcode the date/time value.. is there a way I can use some where clause in the below SQL in the adminstrator tool to get that information? Eg., SELECT COUNT(*) FROM DS_JOBS please let me k...

ok, this means that the I can't preseve the same sorting in the datastage?

the job flow is like this: Dataset1->copy stage->remove duplicate ->dataset2 Dataset1 has records with duplicate key columns. In the copy stage there is a hash partition on the key column and in the remove duplciate there is same partition and sorting is done based on the key column and the duplicat...

mikegohl , thanks for replying.

It is Hash partitioned on the key column and there is no sorting.

mikegohl , thanks for replying.

the Key column is partitioned on Hash and there is no sorting.

Hi, I have a datastage job which uses a dataset as the source (this inturn is created by a file that comes from mainframes) and the job has to remove duplicates based a column and retain the last occurance. In the mainframe file there are 3 occurances for the same column. Basically there are some ot...

Hi, How do I take the count of number of jobs and sequencers in datastage? I tried the following command from datastage Administrator. I got a count and I believe the count is only for the jobs. SELECT COUNT(*) FROM DS_JOBS If this does not count the sequencers, how do I do get the sequencer counts?...