Sign Up Login


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

Write the unconnected lookup syntax?

 821

Write the unconnected lookup syntax and how to return more than one column.

 818

How do you remove duplicate records in informatica? And how many ways are there to do it?

 882

What is dimensional table? Explain the different dimensions.

 871

What are the types of caches in lookup?

 756

What are the types of caches in lookup? Explain them.

 736

Differentiate between router and filter transformation?

 780

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

 1341

What are the differences between oltp and olap?

 709

What are the types of schemas we have in data warehouse and what are the difference between them?

 694

Differentiate between reusable transformation and mapplet.

 816

Why update strategy and union transformations are active?

 789

What is meant by target load plan?

 723

How to join three sources using joiner?

 772

How do you update the records with or without using update strategy?

 854

Post New Informatica Questions

Un-Answered Questions { Informatica }

Define update strategy?

810

what is song in infrmatica...?

1905

What is a filter transformation and why it is an active one?

737

Why filter transformation is an active one?

740

Can we change Dynamic to Static or Persistent cache? If so what happens?

1910




What is parallel processing in informatica?

1267

What is rank transform?

736

State the differences between sql override and lookup override?

831

Explain what are the different versions of informatica?

841

What is an aggregator transformation?

797

Explian the Process of deployment groups in informatica

801

Have you worked with/created Parameter file

1388

What are the new features of Power Center 5.0?

1418

What's the layout of parameter file (what does a parameter file contain?)?

2151

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

988

For More Un-Answered { Informatica } Questions Click Here