Informatica Interview Questions
Questions Answers Views Company eMail

What is a design?

1 3124

How to delete duplicate records in a flat file source?

2 7745

What is a configuration management?

1 3468

How to send duplicates to one target and unique rows to one target?target is empty

Amazon, IBM, Wipro,

9 27987

what is the difference between lookupoveride and joiner?

3 6595

what is plsql table?

2 4787

how to declare array in plsql?

1 8676

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

Cap Gemini, IBM,

4 16631

How many cubes create from a single model?

1 3866

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 5414

how to join the two flatfiles using the joiner t/r if there is no matching port?

Cegedim,

5 11958

How will you display "Mr" for male & "Mrs" for female in target table?

7 10591

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 7234

How will you combine 3 different sources with a single source?

3 7403

how will you get 21 to 30 record from 50 records?

6 9834


Post New Informatica Questions

Un-Answered Questions { Informatica }

is it possible to index the data in cache of lkp transformation ?

1513


What you know about transaction control transformation?

546


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1734


Informatica settings are available in which file?

579


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1068






if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1748


What are the measure objects?

647


Whats there in global repository

1252


How identifying bottlenecks in various components of informatica and resolving them?

573


What are mapplets? How is it different from a Reusable Transformation?

613


What is workflow monitor?

584


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 junk dimensions?

622


how we can load rejected record's at run time?(not through bad files)

1900


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9155