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 …
In Informatica, the best practice is any object used in more than one folder should be created as a shortcut. A Shortcut is a pointer to where the “real” …
For relational database sources, the PowerCenter Informatca Server generates a query for each Source Qualifier transformation when it runs a mapping. The default query is a SELECT statement for …
Rank transformation in Informatica is an active and connected transformation. The rank transformation is used to select the top or bottom rank of data. Rank transformation is equal to …
In Informatica PowerCenter, the different workflow/task status are as follows:
When a DataStage job runs, it creates one or more phantom processes on your DataStage server. Generally, one phantom process for the job, and one for each active stage …
“Phantom” is the name that DataStage uses to mean “background process”. If a process is running and if you kill the process some times the process will be running …
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 …