Informatica Interview Questions
Questions Answers Views Company eMail

How will you update the row without using update statergy?

CTS,

10 12073

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

CTS,

5 9051

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 7487

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

1 2834

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

Accenture,

5 22011

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

Accenture,

4 16090

In operator is used in which transformation in informatica 8.6.0

Virtusa,

5 18752

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 10141

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

Deloitte, IBM, iGate,

11 37407

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 21109

when will we go for unconnected lookup transformation in Informatica?

CTS, IBM,

6 22299

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 8214

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

1 3801

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

1641

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

2 6841


Post New Informatica Questions

Un-Answered Questions { Informatica }

While importing the relational source definition from the database, what are the metadata of source that will be imported?

778


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

7750


What is an unconnected transformation?

654


In warehouses how many schemas are there?

573


What is expression transformation?

620






What is the function of aggregator transformation?

569


What is the use of transformation?

565


How are the sources and targets definitions imported in informatica designer?

661


How to generate sequence numbers using expression transformation?

626


What is Cognos script editor?

3779


How do you take back up of repository?

713


How to open an older version of an object in the workspace?

605


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1117


What is joiner transformation in informatica?

616


Differentiate between sessions and batches?

563