tab1 tab2
1,a 1,d
2,b 3,c
perfoms outerjoin what is the o/p?
write sql query for outerjoin?
Post New Answer View All Answers
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the difference between hashfile and sequential file?
Where the datastage stored his repository?
How a routine is called in datastage job?
I have a few records just I want to store data in to targets cycling way how?
What is merge stage?
Can you explain link buffering?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
how to implement scd2 in datastage 7.5 with lookup stage
What is the difference between validated and compiled in the datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Have you have ever worked in unix environment and why it is useful in datastage?
table actions available in oracle connector?
in oracle target stage when we use load option and when we use upsert option?