DSXchange

I am trying to combine columns from multiple source databases and load into the target database as a single record. I can't use join because there is no common key between those records. Output will be a single record. What is the best way to achieve this?

Can we use SQL result value (select from a db table) as the parameter value in Datastage?

Thank you for the response!

I understood that we can use job parameters by assigning to stage variables in transformer stage. Can we use parameters in Select sql query which we write in DB connector source stage? If so, what is the systax?

Installed Microsoft Visual C++ compiler again and job compiles and runs fine!

Thanks for the responses!

Thanks for the responses!

Looks like C++ compiler was not installed properly. I am installing it now. I will update the outcome here.

yes this is the first time I am compiling the job. I compiled the RowGen -> Transformer -> Peek Job. It is giving the same error as above. I made sure that the compiler environment variables are set correctly. I checked that the Microsoft Visual C++ 2013 is installed in the programs (which is suppor...

I am trying to compile a job with a transformer stage and seeing the below error. This is the first time a job is being compiled after datastage installation. Please help me. ##I IIS-DSEE-TFCN-00006 09:44:02(001) <main_program> conductor uname: -s=Windows Server 2008 R2; -r=Service Pack 1; -v=6.1; -...