Why update strategy and union transformations are active? Explain with examples.
No Answer is Posted For this Question
Be the First to Post Answer
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Explain the shared cache and re-cache?
Is it possible to define a single node as a Gateway node as well as worker node?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
How can you change from reusable session into non-reusable session.
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
4 yrs etl devloper roles and responsibilities?any body give solutions
how can you load data into target table without leading zeor's
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to generate sequence numbers without using the sequence generator transformation?
explain about session partitions ?