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

Write the unconnected lookup syntax?

 646

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

 587

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

 697

What is dimensional table? Explain the different dimensions.

 641

What are the types of caches in lookup?

 560

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

 544

Differentiate between router and filter transformation?

 601

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.

 1031

What are the differences between oltp and olap?

 540

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

 512

Differentiate between reusable transformation and mapplet.

 559

Why update strategy and union transformations are active?

 581

What is meant by target load plan?

 547

How to join three sources using joiner?

 557

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

 650

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the tuning lookup transformation - informatica

602

How to generate sequence numbers?

608

As union transformation gives UNION ALL output, how you will get the UNION output?

635

How to extract the informatica rejected data?

739

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5231




What does “tail –f” command do and what is its use as an Informatica admin.

622

Is it possible to revert a global repository to local one and why?

604

Explain the etl program with few examples.

537

Which is the t/r that builts only single cache memory?

696

what is the size of u r source(like file or table)?

1807

What is the different lookup cache(s)?

600

Explain sql transformation in script mode examples in informatica

589

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2129

can anyone suggest best free Talend data integration training online

1247

what is Active lock explain

2360

For More Un-Answered { Informatica } Questions Click Here