Answer Posted / vamse
not necessarily left outer join. Its inner join most of the time.
Loop up is generally used to fetch data for a particular filter condition.(matching critria should take a particular value from it.
Main table is usually large and look up table is small in ideal scenario.
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
How etl testing is different from database testing?
List few etl bugs?
how do u set partition points in the mapping?
Compare ETL & Manual development?
what is the use of structures?how many nodes can u create in a structure?
What are the different etl testing categories as per their function?
What is a mapping?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
how many maximum session supports to multiload in teradata ??
What do you understand by active and passive transformations?
how would u estimate the size of Aggregator transform data and index cache?
Explain about power designer data modeling software?
what is the difference between cubes and package in cognos
dimension object created in oracle can be imported in designer?how?
What do you understand by the term ‘transformation’?