Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are the key benefits of ETL Testing?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
how many maximum session supports to multiload in teradata ??
when will use SQL override in a lookup transformation?
What are snapshots?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what is a worklet?
what are the reporting tools and difference between them?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
What are cubes and olap cubes?
List few etl bugs?
what is different between sequential batch and concurrent batch and which is recommended and why?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
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
