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

Informatica Interview Questions

Questions Answers Views Company eMail

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

Deloitte,

15 35253

how to run the batch using pmcmd command

Wipro,

2 14304

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 12698

what is diffrence b/w joner and union transfermation

6 15782

which quality process u can approach in ur project

CTS,

1 7792

how can u approach u r client

CTS,

2 8213

how can u tune u r informatica mapppings

CTS,

2 9537

how to load duplicate row in a target

4 10333

what are testing in a mapping level please give brif eplanation

CTS,

1 8091

what is upstream and downstream transformation?

7 36175

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

Accenture,

3 14831

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

Accenture,

6 20940

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 8437

in reporting we add some new objects,how we get the count of the newly added objects to the report

HP,

2254

what is mean by grouping of condition column in lookup transformation?

1 6623

Post New Informatica Questions

Un-Answered Questions { Informatica }

What do you mean by channel change?

1113

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2088

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1061

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2074

What is the reusable transformation?

1105

What is the difference between Active and Passive transformation?

1225

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

1083

what is the difference between informatica6.1 and infomatica7.1

2366

How can we use mapping variables in informatica? Where do we use them?

1295

What is a mapplet/worklet in informatica?

1249

4 yrs etl devloper roles and responsibilities?any body give solutions

2253

Explain pushdown optimization and types in informatica

1124

How many input parameters can exist in an unconnected lookup?

1605

What is status code in informatica?

1067

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1214

For More Un-Answered { Informatica } Questions Click Here