Informatica Interview Questions
Questions Answers Views Company eMail

Define informatica repository?

Wipro,

2 11508

What are the types of metadata that stores in repository?

2 10537

What is tracing level and what are the types of tracing level?

TCS,

2 37494

What are Target Options on the Servers?

1 5572

What is Code Page Compatibility?

1 8477

What are Dimensions and various types of Dimensions?

PayPal, TCS,

3 41598

Why we use lookup transformations?

1 5972

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

TCS,

5 18154

Explain about perform recovery?

1 6177

How to recover sessions in concurrent batches?

1 11632

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 5803

How to recover the standalone session?

2 8808

What is difference between maplet and reusable transformation?

2 9427

What are the data movement modes in informatcia?

3 6953

What are the out put files that the informatica server creates during the session running?

2 7336


Post New Informatica Questions

Un-Answered Questions { Informatica }

How to partition the Session?

843


What is expression transformation?

829


write a query to retrieve the latest records from the table sorted by version(scd)

843


What are session parameters ? How do you set them?

1575


What are the basic requirements to join two sources in a source qualifier transformation using default join?

811


Write the prerequisite tasks to achieve the session partition?

843


COM components can be used in Informatica

2093


What all are steps in up gradation of Informatica server?

805


Explain pmcmd command usage in informatica

901


What are the uses of etl tools?

851


Can you generate sequence numbers without using the sequence generator transformation?

829


What is joiner transformation?

756


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1551


lookup transformation with screenshots

3767


How to extract sap data using informatica? What is abap? What are idocs?

814