Category Archives: ETL Interview Questions

What are mapping parameters and mapping variables? | ETL Questions

Mapping parameters are parameters which are constant through out the session. They are specified before running the session. Unlike parameters, variables change through out the session.

Posted in ETL Interview Questions | Leave a comment

Why do we use partitioning the session in Informatica? | ETL Questions

Partitioning achieves the session performance by reducing the time period of reading the source and loading the data into target.

Posted in ETL Interview Questions | Leave a comment

To achieve the session partition what are the necessary tasks you have to do? | ETL Questions

Configure the session to partition source data. Install the Informatica server on a machine with multiple CPU’s.

Posted in ETL Interview Questions | Leave a comment

What is a command that used to run a batch? | ETL Questions

pmcmd is used to start a batch.

Posted in ETL Interview Questions | Leave a comment

When the Informatica server marks that a batch is failed? | ETL Questions

If one of session is configured to “run if previous completes” and that previous session fails.

Posted in ETL Interview Questions | Leave a comment

What is a command that used to run a batch? | ETL Questions

pmcmd is used to start a batch.

Posted in ETL Interview Questions | Leave a comment

What are the different options used to configure the sequential batches? | ETL Questions

Two options Run the session only if previous session completes successfully. Always runs the session.

Posted in ETL Interview Questions | Leave a comment

How can you recognize whether or not the newly added rows in the source are getting inserted in the target? | ETL Questions

In the Type2 mapping we have three options to recognize the newly added rows Version number Flag value, Effective date Range.

Posted in ETL Interview Questions | Leave a comment

Can you start a session within a batch individually? | ETL Questions

Let me tell you that one can start the sessions in this way in the case of sequential batches only. In case of the concurrent batches it is virtually impossible.

Posted in ETL Interview Questions | Leave a comment

What is constraint based loading ? | ETL Questions

Constraint based loading. the data was loaded into the target table based on the Constraints.i.e if we want to load the EMP&DEPT data, first it loads the data of DEPT then EMP because DEPT is PARENT table EMP is CHILD … Continue reading

Posted in ETL Interview Questions | Leave a comment