Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

How will you update the row without using update statergy?

CTS,

10 14937

How will you update the first four rows and insert next four rows in a mapping?

CTS,

5 10867

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

Wipro,

1 8291

any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 4031

how to join the 2 different table with different columns in informatica?

Accenture,

5 23730

How to load the source table into flat file target(with columns) in informatica?

Accenture,

4 17691

In operator is used in which transformation in informatica 8.6.0

Virtusa,

5 20669

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

IBM,

5 11793

How we can get unique records into one target table and duplicate records into another target table??

Deloitte, IBM, iGate,

11 41248

How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,

1 22086

when will we go for unconnected lookup transformation in Informatica?

CTS, IBM,

6 24564

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 9349

hi all, Can anyone please tell me the relationship between informatica and business objects

1 4569

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2169

How to load duplicate records in to a target table which has a primary key?

2 7867

Post New Informatica Questions

Un-Answered Questions { Informatica }

How do you use reject loader.

2603

what is the size of your data warehousing?

2095

What is lookup change?

1048

Explain what are the different versions of informatica?

1098

what is degenerated dimension?

3997

What are the main issues while working with flat files as source and as targets ?

1159

Describe an informatica powercenter?

1127

How to do the error handling of if ur source is flatfiles?

1968

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

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

2003

Can we create a Integration service without a Repository service and vice versa?

1215

Enlist the various types of transformations.

1057

Informatica settings are available in which file?

990

can u give example for factless fact table

6649

Write the different tools in the workflow manager?

1066

For More Un-Answered { Informatica } Questions Click Here