Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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,

14 23992

how to run the batch using pmcmd command

Wipro,

2 12046

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 9632

what is diffrence b/w joner and union transfermation

6 12038

which quality process u can approach in ur project

CTS,

1 6132

how can u approach u r client

CTS,

2 6072

how can u tune u r informatica mapppings

CTS,

2 7735

how to load duplicate row in a target

4 7476

what are testing in a mapping level please give brif eplanation

CTS,

1 6336

what is upstream and downstream transformation?

7 28356

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

Accenture,

3 11337

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 16448

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

3 6054

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

HP,

1374

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

1 5214


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is a difference between complete, stop and abort?

235


Enlist the various types of transformations.

221


What is meant by LDAP users?

256


What is predefined event?

270


Briefly define a session task?

234






How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

265


What is persistent lookup cache?

207


list out all the transformations which use cache?

261


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

240


What is a router transformation?

247


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1353


How to generate or load values in to the target table based on a column value using informatica etl tool.

231


What are multi-group transformations?

250


Explain the tuning lookup transformation - informatica

247


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

264