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

Write the unconnected lookup syntax?

 648

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

 590

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

 699

What is dimensional table? Explain the different dimensions.

 645

What are the types of caches in lookup?

 562

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

 545

Differentiate between router and filter transformation?

 604

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.

 1034

What are the differences between oltp and olap?

 542

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.

 560

Why update strategy and union transformations are active?

 585

What is meant by target load plan?

 548

How to join three sources using joiner?

 561

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

 653

Post New Informatica Questions

Un-Answered Questions { Informatica }

On which transformations you created partitions in your project?

757

what is the complex transformation you used in informatica

2183

How can we use mapping variables in informatica? Where do we use them?

616

What is an unconnected transformation?

657

What are multi-group transformations?

554




How can we use batches?

598

How to call shell scripts from informatica?

567

How to elaborate tracing level?

678

Differentiate between joiner and lookup transformation?

606

What are the tuning techniques you applied during your last project

1553

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5556

Explain incremental aggregation in informatica

647

What is Data Caches size?

652

What is decode in static cache?

584

What are the various types of transformation?

638

For More Un-Answered { Informatica } Questions Click Here