Category: INFORMATICA INTERVIEW QUESTIONS

1. What is a data warehouse? A data warehouse is the electronic storage of an organization’s historical data for the purpose of data analytics. In other words, a data …

The main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the …

Read previous post: Informatica interview questions and answers-2 20. How to make dependency between workflows (which are in different folders) without using any third-party scheduler? We can use pmcmd …

What is the difference between normal load and Bulk load in session properties? Bulk loading improves the performance of a session that inserts a large amount of data to …

Connected Lookup Unconnected Lookup Receives input values directly from the pipeline. Receives input values from the result of a :LKP expression in another transformation You can use a dynamic …