What is the main purpose of Unconnected lookup other than
updating slowly changing dimensions?
or In which case u use Unconnected lookup?
Answer Posted / praveenabhaskar
We can use unconnected lookup transformation when we have
multiple inputs and single output.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
In warehouses how many schemas are there?
Define update strategy?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is rank transformation?
What is data caches/ index caches?
What are the issues you have faced in your project? How did you overcome those issues?
What is the cumulative sum and moving sum?
Differences between connected and unconnected lookup?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
what is the hint? how to use it to reduce the query processing in program?
What is decode in static cache?
What could be the possible resons of locks by user?
Mention few advantages of router transformation over filter transformation.
What do you mean by blocking transformation?