Informatica Interview Questions
Questions Answers Views Company eMail

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 3278

What is the difference between normal and bulk loading? Which one is recommended?

1 4975

What is a test load?

1 3233

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 4070

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 5239

What is mapplet and a reusable transformation?

2 4057

How do you implement configuration management in Informatica?

1 3021

What are Business Components in Informatica?

1 4229

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

1923

COM components can be used in Informatica

1861

What is the advantage of persistent cache? When it should be used.

Wipro,

1 5470

When will you use SQL override in a lookup transformation?

1 5081

Two different admin users created for repository are ______ and_______

1 3705

Two Default User groups created in the repository are ____ and ______

2 6634

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 3936


Post New Informatica Questions

Un-Answered Questions { Informatica }

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1516


How to update a particular record in target with out running whole workflow?

1147


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1038


How do you load only null records into target?

727


Can informatica load heterogeneous targets from heterogeneous sources?

687






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

6384


Different circumstance which drives informatica server to expel records?

545


What is difference between a gateway node and worker node?

610


How to extract the informatica rejected data?

739


What is a shortcut and copy in Informatica and how two are different with each other?

666


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1738


What is sq transformation?

652


Explain your project of banking domian.

1208


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7749


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1021