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

Informatica Interview Questions

Questions Answers Views Company eMail

Define informatica repository?

Wipro,

2 12174

What are the types of metadata that stores in repository?

2 11148

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

TCS,

2 38282

What are Target Options on the Servers?

1 6150

What is Code Page Compatibility?

1 8957

What are Dimensions and various types of Dimensions?

PayPal, TCS,

3 42541

Why we use lookup transformations?

1 6397

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

TCS,

5 19329

Explain about perform recovery?

1 6905

How to recover sessions in concurrent batches?

1 12410

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

2 6520

How to recover the standalone session?

2 9577

What is difference between maplet and reusable transformation?

2 10090

What are the data movement modes in informatcia?

3 7752

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

2 7958

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is InformaticaPowerCenter?

1179

Explain the features of connected and unconnected lookup.

978

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2188

What is source qualifier transformation in informatica?

1066

Does an informatica transformation support only aggregate expressions?

1089

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1846

What is native users?

1226

What is a shortcut and copy in Informatica and how two are different with each other?

1245

Explain load alternative records / rows into multiple targets - informatica

1206

What is meant by incremental aggregation?

1186

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

1950

differences between service based and product based?

2060

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1149

What is joiner transformation?

1067

What are the different transaction levels available in transaction control transformation?

1279

For More Un-Answered { Informatica } Questions Click Here