How to write a left outer join condition by using
Transformer stage in server jobs?
Could any one help me?
- 1 Answers
- 11657 Views
- I also Faced
- E-Mail Answers
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 is staging variable?
How to reverse the string using unix?
Differentiate between validated and Compiled in the Datastage?
Terminate Activity
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
what is the diff between sequential file and fileset stages?
EXPLAIN SCD
how many stages are there in Datastage... Please clarify mee??
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
how to retrive the max(sal),deptno,empno in datastage?
Nls stands for what in datastage?
Teradata 
