Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sunil
Lookup works as Master outer Join in informatica ..
Oracle--> its works as left outer join..
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
What are the various tools used in etl?
what are the reports developed in sap bw project and what is the requirement for developing it?
Explain about enterprise scalability and roi of data integration suite?
Explain about power designer data modeling software?
What are the names of the layers in etl?
What is the difference between round-robin partitioning and hash partitioning?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
what is the difference between cardinality and Nullability?
Explain the use lookup tables and Aggregate tables?
What is data cleaning?
What is initial load and what is full load?
what are the session parameters? How do u set them?
what is different between sequential batch and concurrent batch and which is recommended and why?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
