How many rounds of interview are there in Informatica?

How many rounds of interview are there in Informatica?

Informatica conducts 5-6 rounds to select freshers as Software Engineer in their organisation.

How can one identify whether mapping is correct or not without connecting session?

How can one identify whether mapping is correct or not without connecting session? One can find whether the session is correct or not without connecting the session is with the help of debugging option. 13.

What are some scenario questions?

20 Common Situational Interview Questions

• Tell me about a time you went above and beyond for work.
• Tell me about a time you had to choose something else over doing a good job.
• Describe a situation where you weren’t satisfied with your job.
• Tell me about a time you reached a big goal at work.

How do you answer scenario questions?

Use the following steps to answer situational interview questions:

1. Explain the situation. You’ll first need to explain the similar situation you’re using to answer the question before you get into what you did to solve it.
2. Describe the problem.
3. Outline the action you took to remedy the problem.
4. Talk about the results.

How do I load last n records in Informatica?

Load Last N Records of File into Target Table – Informatica

1. Connect the expression to a filter transformation and specify the filter condition as o_count = 1.
2. Connect the filter to the target and save the mapping.

How do I load half records in Informatica?

The requirement is to process only half of the records from the source table. To do this we need to calculate the total number of rows (TOTAL-COUNT) in the source table and then assign ROW-COUNT and exclude the rows if the ROW-COUNT <= (TOTAL-COUNT/2).

What is SCD Type 2 in Informatica in interview?

SCD type 2 will store the entire history in the dimension table. In SCD type 2 effective date, the dimension table will have Start_Date (Begin_Date) and End_Date as the fields. If the End_Date is Null, then it indicates the current row. Know more about SCDs at Slowly Changing Dimensions Concepts.

What are scenario based questions examples?

How do I separate unique and duplicate records in Informatica?

4 Answers

1. Load the data to a temp table and then just select the distinct records.
2. Use a sorter or aggregator transformation and then select the distinct option (In the properties tab if I remember correctly)
3. Use the dynamic lookup which will only insert records into the cache if they have not been inserted already.

https://www.youtube.com/watch?v=8AZP_kjO3mw