1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

What are the differences between source qualifier and joiner transformation?

 587

How do you convert single row from source into three rows into target?

 591

What are the types of schemas we have in data warehouse.

 518

Why update strategy and union transformations are active? Explain with examples.

 697

How do you remove duplicate records in informatica?

 1 700

How do you load alternate records into different tables through mapping flow?

 1278

How do you load first and last records into target table?

 653

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

 762

Explain in detail scd type 2 through mapping.

 605

How do you load unique records into one target table and duplicate records into a different target table?

 693

Explain the different kinds of facts.

 554

How do you load only null records into target?

 727

What is fact table? Explain the different kinds of facts.

 601

How many ways are there to do 'remove duplicate records in informatica'?

 574

How to join three sources using joiner? Explain though mapping flow.

 682

Post New Informatica Questions

Un-Answered Questions { Informatica }

Which transformation is needed while using the Cobol sources as source definitions?

717

How to create a non-reusable instance of reusable transformations?

666

Explain the types of lookup transformation?

554

What are the tasks that can be performed using sq?

600

Can we override a native sql query within informatica?

620




How to load data in informatica ?

558

Explain the informatica workflow?

577

What is meant by lookup transformation?

601

Enlist the various types of transformations.

546

How to partition the Session?

636

Describe the impact of several join conditions and join order in a joiner transformation?

632

What is meant by target load plan?

546

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6384

What is the benefit of session partitioning?

584

How you know when to use a static cache and dynamic cache in lookup transformation?

1327

For More Un-Answered { Informatica } Questions Click Here