Hi Guys,
I have modified a few list of jobs over the past few months.
Now, i want to identify the jobs which got modified.
Is there a way to find the jobs which got modified by their time stamp. Or is there any tool from which this can be achieved.
Cheers!!!
Search found 19 matches
- Tue Nov 01, 2016 12:57 am
- Forum: General
- Topic: To identify the list of jobs which got modified recently
- Replies: 3
- Views: 2365
- Wed Mar 16, 2016 2:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Load SQL from file at run-time
- Replies: 3
- Views: 6504
Load SQL from file at run-time
Hi, I am trying to load AQL from a file which is created from another job. I am using Oracle OCI stage. In the Stage Tab, i have given the correct credentials. In the Output tab, in General Tab, i have selected "Load SQL from file at Runtime". In Columns under Output, i have given the outp...
- Wed Aug 12, 2015 3:45 am
- Forum: General
- Topic: Way to Retrieve the Transformations of a Job
- Replies: 17
- Views: 8713
Following is the query i am using. But the Transformation column is coming as Null. select a.DSNAMESPACE_XMETA Projname,a.category_xmeta folder_name, a.NAME_XMETA as Job_Name,b.name_xmeta as Stage_Name, d.name_xmeta Link_Name,e.sourcecolumn_xmeta Target_Column,e.expression_xmeta Transformation from ...
- Mon Aug 10, 2015 12:12 am
- Forum: General
- Topic: Way to Retrieve the Transformations of a Job
- Replies: 17
- Views: 8713
Ray, the problem we have only individual jobs and no sequencer. The sequencing is done in Control-M scheduler.. So, not sure if data lineage for a single job can be done.ray.wurlod wrote:If you have Metadata Workbench you can request a data lineage report that will give you the transformations. ...
- Mon Aug 10, 2015 12:09 am
- Forum: General
- Topic: Way to Retrieve the Transformations of a Job
- Replies: 17
- Views: 8713
Yes, Table datastagex_dstransformc2e76d84 contains only Transform functions. I have almost found the solution. So, i have joined the below four tables and got all the stages and links present in each job. datastagex_dsjobdefc2e76d84 a, datastagex_dsstagec2e76d84 b,datastagex_dsoutputpinc2e76d84 c, d...
- Fri Aug 07, 2015 12:47 am
- Forum: General
- Topic: Way to Retrieve the Transformations of a Job
- Replies: 17
- Views: 8713
Guys, may be i have not explained properly. I am trying to figure out given a job name, i want to retrieve all the source columns and their associated transformations and their respective target columns. I am Looking at XMETA now. I am able to list all the stages associated with each job using the b...
- Thu Aug 06, 2015 4:28 am
- Forum: General
- Topic: Way to Retrieve the Transformations of a Job
- Replies: 17
- Views: 8713
Way to Retrieve the Transformations of a Job
Hi Guys,
I am trying to do reverse engineering. I am trying to retrieve all the transformations of each job present in my project.
Is there command/routine to retrieve all the transformations happening in a job.
Cheers!!!
I am trying to do reverse engineering. I am trying to retrieve all the transformations of each job present in my project.
Is there command/routine to retrieve all the transformations happening in a job.
Cheers!!!
- Fri Nov 14, 2014 1:52 am
- Forum: General
- Topic: istool: help with import error
- Replies: 5
- Views: 3807
- Fri Nov 14, 2014 1:31 am
- Forum: General
- Topic: istool: help with import error
- Replies: 5
- Views: 3807
istool: help with import error
One of my teammate has imported a wrong version of code to my project. But before that luckily, my export command ran which created a backup *.isx file. I am using the following command to import the isx file. cd <cli path> ./istool import -dom xx:xx -u xxx -p xx -ar <Path>/SG_backup.isx -replace -d...
- Thu Apr 10, 2014 6:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading Timestamp into Oracle
- Replies: 9
- Views: 4773
- Fri Jan 24, 2014 9:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Startup error on node3 connecting with conductor
- Replies: 2
- Views: 2555
Re: Startup error on node3 connecting with conductor on .ser
Oh, Unix/datastage admin who actually installed datastage need to have a look I think. Couple of questions: 1)Is the issue occurring only with 'node3' always. If yes, try analyzing what's unique with the node3 content. 2)Does it occur with every job, every time. Has any job run successfully ever in ...
- Thu Jan 23, 2014 10:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: use DB seq value in the job
- Replies: 5
- Views: 3410
Re: use DB seq value in the job
1) Yes, NextSurrogateKey() funtion will work in the way you expect.
2) Yes, you can pass the stage variable value to a file/dataset and use it next job as you wish.
2) Yes, you can pass the stage variable value to a file/dataset and use it next job as you wish.
- Thu Jan 23, 2014 5:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: create multiple xml files during datastage runtime.
- Replies: 3
- Views: 2635
create multiple xml files during datastage runtime.
You can create a single large file, then write a small Unix script to split and rename the files as per your requirement. This will be many times faster then your current approach.
- Thu Jan 23, 2014 5:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Startup error on node3 connecting with conductor
- Replies: 2
- Views: 2555
Re: Startup error on node3 connecting with conductor on .ser
Seems to be Unix server side connection issue. Check the contents of Node3 of your config file and reach out to Unix Admin with the 'fastname' and error message, they should be able to resolve.
If no luck, you may need to provide a different server as your Node3.
If no luck, you may need to provide a different server as your Node3.
- Thu Jan 23, 2014 5:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ODBC Connector truncates exceeding length column values
- Replies: 3
- Views: 2140
ODBC Connector truncates exceeding length column values
Is 'Fail on size mismatch' option under 'Schema Reconciliation' set to YES in ODBC Connector. That's the option to catch schema mismatch errors.
If no luck, you may have to look for IBM patch documentation for ODBC connector stage.
If no luck, you may have to look for IBM patch documentation for ODBC connector stage.