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

Informatica Interview Questions

Questions Answers Views Company eMail

In which circumstances that informatica server creates Reject files?

2 8098

What is polling?

1 7350

Can you copy the session to a different folder or repository?

1 6649

What is batch and describe about types of batches?

2 12173

Can you copy the batches?

3 10615

How many number of sessions that u can create in a batch?

3 10493

When the informatica server marks that a batch is failed?

2 6649

What is a command that used to run a batch?

4 12061

What are the different options used to configure the sequential batches?

Wipro,

2 9182

In a sequential batch can u run the session if previous session fails?

3 7046

Can you start a batches with in a batch?

1 6177

Can you start a session inside a batch individually?

2 9270

How can u stop a batch?

2 6933

What are the session parameters?

3 15189

What is parameter file?

2 6782

Post New Informatica Questions

Un-Answered Questions { Informatica }

Briefly explain the aggregator transformation?

993

Enlist some properties of sessions.

1063

How would you copy the content of one repository to another repository?

1014

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1038

What is incremental aggregation?

1077

Differentiate between joiner and lookup transformation?

1100

Briefly define reusable transformation?

1125

What are the types of lookup transformation?

1070

Design a mapping to load the cumulative sum of salaries of employees into target table?

1498

How do you load unique records into one target table and duplicate records into a different target table?

1237

What is the difference between router and filter?

1260

How do you change a non-reusable transformation to reusable transformation?

994

How to create Target definition for flat files?

1211

What are the restrictions of union transformation?

1037

Explain sessions. Explain how batches are used to combine executions?

1024

For More Un-Answered { Informatica } Questions Click Here