DSXchange

HOW TO DO LEFT OR RIGHT JOIN?

and what should be the value field in DS administrator for the environment variable be? i mean it should be blank or $ENV?

i am sorry. actually i was asking how to execute the batch file in the same shell. can you please explain it to me. thanks

i read that transformer performs equii join. and even in the job it is performing equii join. is anything that i can specify to make it a left or right or full outer or inner depending on what the result should be?

Hi, i have two tables, primary in oracle and reference table in SQL server. i want to perform outer(left or right or full) on these tables in server jobs. can anyone explain how to do this. i cannot move any of the tables into other schema or database. and can i specify anything in the transformer w...

"What you can do is have DataStage write a BAT file that sets the environment variable based on the received value. Then, in the shell that invoked DataStage, you can execute that BAT file. "


can you explain how to do this.? i have no clue how that can be done.

hi,

i need to set environment variable from a file or table ( preferred) either outside or inside datastage. the OS is windows. i have tried searching the forum but couldnt find a solution. if the topic is posted please direct to the link or please let me know the solution.

thanks in advance.

i was asking about implementing slowly changing dimensions ?

someone please let me know how to proceed with the job design. this is really urgent for me as i have to start from here without which i cannot proceed.

thanks in advance

could some one help me with the job design in sever edition where i want to capture changes in database. for example the source master has columns c#(pk), cname, address. c1 , abc , usa c2 , xyz , uk and the target dimension should look like c#, cname, address, start_date, end_date, current_flag. c1...