DSXchange

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!!!

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...

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 ...

ray.wurlod wrote:If you have Metadata Workbench you can request a data lineage report that will give you the transformations. ...

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.

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...

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...

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!!!

Yeah chulett.. I too thought so,, so i have created my own post. Can you point out as what wrong i have done.

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...

Your record in 9.1 has data 25-Feb-2014 12:00:00.00000 which is correct in your target. Similarly with 8.5 also.

so what are you expecting as your output?

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 ...

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.

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.

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.

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.