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 34743

how to run the batch using pmcmd command

Wipro,

2 14172

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 12551

what is diffrence b/w joner and union transfermation

6 15611

which quality process u can approach in ur project

CTS,

1 7712

how can u approach u r client

CTS,

2 8094

how can u tune u r informatica mapppings

CTS,

2 9441

how to load duplicate row in a target

4 10195

what are testing in a mapping level please give brif eplanation

CTS,

1 8000

what is upstream and downstream transformation?

7 35887

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

Accenture,

3 14693

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 20711

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

3 8293

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

HP,

2192

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

1 6507

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to join three sources using joiner?

1113

How might one distinguish in the case of mapping is right or not without associating session?

1119

In warehouses how many schemas are there?

1073

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2075

How do you load first and last records into target table?

1159

What do you mean by channel change?

1043

As union transformation gives UNION ALL output, how you will get the UNION output?

1107

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1132

Please let me know how to make encryption and decryption with example?

1900

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1995

Name the different lookup cache(s)?

1233

Target increases every day even though no new record was inserted

1580

What is a grid in Informatica?

1069

Is there any target staging area in informatica not staging area

2578

What is workflow? What are the components of workflow manager?

1177

For More Un-Answered { Informatica } Questions Click Here