⟩ Explain Partitioning types?
Available partitioning types in Oracle database are as under:
Range partitioning
Hash partitioning
Composite partitioning
List partitioning
Interval partitioning
System partitioning
Reference partitioning
Available partitioning types in Oracle database are as under:
Range partitioning
Hash partitioning
Composite partitioning
List partitioning
Interval partitioning
System partitioning
Reference partitioning
What are the reusable transforamtions?
What are Aggregate transformation?
Suppose if a session fails after loading of 10,000 records in to the target.How can you load the records from 10001 the record when you run the session next time?
What is the difference between Power Center and Power Mart? What is the procedure for creating Independent Data Marts from Informatica 7.1?
Explain What is the limit to the number of sources and targets you can have in a mapping?
Explain Where to store informatica rejected data? How to extract the informatica rejected data?
Explain How many types of dimensions are available in Informatica?
What is Session and Batches?
Explain What are the tasks that Loadmanger process will do?
Explain What is batch and describe about types of batches?