Interested to Buy Any Domain ? << Click Here >> for more details...
How to write a left outer join condition by using
Transformer stage in server jobs?
Could any one help me?
- 1 Answers
- 12534 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many Key we can define in remove duplicate stage?
What are transforms and what is the differenece between routines and transforms?
How complex jobs are implemented in datstage to improve performance?
In Datastage, how you can fix the truncated data error?
What are orabulk and bcp stages?
What are the different type of jobs in datastage?
How do you run datastage job from the command line?
How to reverse the string using unix?
What are system variables and sequencers in datastage
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Name the different sorting methods in datastage.
What are the types of views in datastage director?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the use of hoursfromtime() function in transformer stage in datastage?
Define orabulk and bcp stages?
