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 14936

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

CTS,

5 10866

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 17690

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 11792

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

Deloitte, IBM, iGate,

11 41243

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 24563

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 }

What is expression transformation?

1100

How many ways a relational source definition can be updated and what are they?

1017

Explain the different lookup methods used in informatica?

1042

Explain the features of connected and unconnected lookup.

935

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2305

What is mapplet in informatica?

1057

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1263

what is diff b/t sorter t/r and agg have the option sorter property...

2171

What are Dimensional table?

1055

What are active transformations.

1654

What could be the possible resons of locks by user?

1094

Can informatica load heterogeneous targets from heterogeneous sources?

1187

Repository user profiles

1762

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2008

What is domain in terms of informatica?

1007

For More Un-Answered { Informatica } Questions Click Here