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
what is data modeling?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what are Lookup caches options? Including persistent caches.
What are the names of the layers in etl?
How many types of transformations supported by sorted input?
What is abap? What are idocs?
Can u access a repository created in previous version of Informatica?
how to load the data to fact table?
What is tracing level?
what is the difference between cardinality and Nullability?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
can cubes contain measures ?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is different between sequential batch and concurrent batch and which is recommended and why?