What is partitioning? Explain different types of partitioning?
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
What is staging area referring to?
Can we create Hierarchies in generic datasources?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
What is etl tool in hadoop?
what are the session parameters? How do u set them?
Explain about hash partitioning?
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
Explain about round-robi?
what is the difference between cubes and package in cognos
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?