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.
Search found 131 matches
- Sun Dec 05, 2010 11:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: handle different metadata using a single job?
- Replies: 6
- Views: 3895
- Fri Jun 18, 2010 12:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job with "RunJob" is not getting complied
- Replies: 1
- Views: 1632
Job with "RunJob" is not getting complied
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...
- Mon May 31, 2010 12:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dynamic lookup in DS
- Replies: 2
- Views: 2364
Dynamic lookup in DS
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...
- Mon Jan 04, 2010 3:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find for a particular object
- Replies: 2
- Views: 1775
- Mon Jan 04, 2010 3:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find for a particular object
- Replies: 2
- Views: 1775
How to find for a particular object
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
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
- Tue Sep 08, 2009 11:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maintain sort order in datastage
- Replies: 10
- Views: 25324
- Tue Sep 08, 2009 9:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Maintain sort order in datastage
- Replies: 10
- Views: 25324
Maintain sort order in datastage
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...
- Thu Jun 18, 2009 1:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find the job run times?
- Replies: 6
- Views: 2651
- Thu Jun 18, 2009 12:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to find the job run times?
- Replies: 6
- Views: 2651
How to find the job run times?
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...
- Thu Apr 30, 2009 2:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issues in selecting the last occurance in the datastage job
- Replies: 10
- Views: 4650
- Thu Apr 30, 2009 1:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issues in selecting the last occurance in the datastage job
- Replies: 10
- Views: 4650
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...
- Thu Apr 30, 2009 1:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issues in selecting the last occurance in the datastage job
- Replies: 10
- Views: 4650
- Thu Apr 30, 2009 1:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issues in selecting the last occurance in the datastage job
- Replies: 10
- Views: 4650
- Thu Apr 30, 2009 11:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issues in selecting the last occurance in the datastage job
- Replies: 10
- Views: 4650
Issues in selecting the last occurance in the datastage job
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...
- Tue Mar 03, 2009 3:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Count of number of jobs
- Replies: 3
- Views: 1862
Count of number of jobs
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?...