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
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
where are the log files generally stored.Can you change the path of the file.what can the path be?
what is dynamic insert?
Explain what is etl process? How many steps etl contains explain with example?
How etl testing is different from database testing?
how do u set partition points in the mapping?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
What are the etl testing operations includes?
Do we need an etl tool?
What is tracing level and what are the types?
how does the server recongnise the source and target databases.Elaborate on this
Which transformation we use to convert 'NA' to 'Not Available'
What are the types of Data Warehouse applications?
what is the difference steps for data modeling?