Informatica Interview Questions
Questions Answers Views Company eMail

Explain the flow of data in Iinformatica?

1 9060

What are the new features of informatica 7.1?

2 6398

What are teh different tasks that can be created in workflow manager?

NIIT,

1 9305

What is the functionality of update strategy?

2 8302

Name 4 output files that informatica server creates during session running?

1 12764

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 13757

What are limitations of joiner transformation?

Exilant, TCS,

2 19854

can we generate reports in informatica ? How?

3 20391

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 6400

How can we eliminate duplicate rows from flatfile,explain?

3 10495

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 6024

AT the max how many transformations and mapplets can we use in a mapping ?

Cap Gemini, Cognizant,

1 16219

What are slowly changing dimensions?

Informatica, Verinon Technology Solutions,

5 28718

What is the difference between OLTP and ODS?

4 25786

What is status code?

2 6125


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

762


Explian the Process of deployment groups in informatica

632


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1613


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

604


Explain the difference between a data warehouse and a data mart?

575






Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1515


Is there any way to read the ms excel datas directly into informatica?

528


How do you load first and last records into target table?

641


What is an Integration service in Informatica?

681


differences between service based and product based?

1546


If informatica has its scheduler why using third party scheduler?

743


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4732


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

665


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

542


During the running session, output files are created by informatica server. Enlist few of them.

520