How to write a left outer join condition by using
Transformer stage in server jobs?
Could any one help me?
Answer / rakesh
default is left outer join Dude you just make sure in transformer you joiin them based n the key, that's it
| Is This Answer Correct ? | 3 Yes | 10 No |
What are system variables and sequencers in datastage
what r the stages mostly used in realtime scenarios
How to create user defined environment varibale(parameter)?
How can you find out whether datastage process is running or not in unix?
how to do pergformence tuning in datastage?
What are the different options associated with dsjob command?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
How to find value from a column in a dataset?
How a source file is populated?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?