DSXchange

All, I have a requirement to pass a value from transformer stage (one of the column say 'Dummy' which has distinct values) and i need to assign this value to the xml file name in xml write stage instead of static name. So whenever there is a distinct value encounter, the corresponding xml should hav...

Hi all, I have a job to call the web service but i ended up with the below error. Can anyone experienced the same issue? Pls advice. also is there any possibility to check/verify any particular web service could be called from datastage or not . Web_Services_Transformer_38,0: Fatal Error: Fatal: 002...

Hi all, I have a datasource which has 10 tables with millions of data each (say transactions about employee (employee id) . I have another reference table which has only employee ids and I need to do a profiling on each of the table by referring the key value (employee id) of each employee in that r...

Thanx Arvind for your comments..

The sequence is a scheduled one. During the initial execution, it will carry one value and at the end of the job execution, the value need to be assigned with a different value. I just want to know how to modify the value of that environmental variable in datastage.

I want to be bit clear.. Its datastage administrator variable, not the one in my computer.. I want to dynamically assign/modify the values in the environmental variable not static.

I have a requirement, i need to change the value of the existing environmental variable after the completion of job execution.? Can anyone pls tell us the solution if you have cme across.

Thanks Craig.
I believe there is no such nature in the FTP EStage.

Hi all,

I have completed this activity thru unix scripts. Because FTP Estage does not have this nature.

Hi everyone,
I have a requirement to read a file from a FTP path and move it to unix box and after reading it, the file should be deleted in ftp. Can we do this in FTP Enterprise stage. Please suggest a solution for this.

Thanks in advance..

Thanks ray, other application interventions may occur, so created a user defined sql which resolves my requirement. But still i dont know how to use the sequence in skg stage..

Dear all, Two questions: 1. I could establish the Surogate key generation through flat file. Can you explain how to generate it through DB2 sequence. 2. I have a scenario: Input : Dataset -- 2 million records contains (empname,esal) In target DB2 table say EMP (empid is a sequence generator). For ev...

Priya,

the data load will be around some 500K so, is this preferable to take on sparse matrix.

Mansoor - I need to pass the dataset value dynamically inside the database query.
The database has the query but does not have data in load.

Hi guys, I have a set of values in a dataset. I need to pass this value in oracle stage query window. Can any one suggest a solution if you come across. Eg: Dataset has thousands of reocrds. 156 245 335 424 . . . 1454 in the Database stage i have the query Select * from empy where emp_ID = Dataset V...

[quote="DSguru2B"]This is where recursive sql comes in. If your source is DB2, look into the 'WITH' clause and in oracle its 'connect_by_prior'. ...[/quote]

Thanks Dsguru. when i used "connect by prior" it works fine.

Guys, This may sound silly, but i dont know this could be achieved in datastage or through simply query, dont go for any stored procedures. Let me describe with simple example. I have a table with rows A B 1 2 2 3 If we look into the relationship of the element B with element A for the value as '3' ...