1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

Define informatica repository?

Wipro,

2 11039

What are the types of metadata that stores in repository?

 2 10073

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

TCS,

2 36821

What are Target Options on the Servers?

1 5261

What is Code Page Compatibility?

1 8126

What are Dimensions and various types of Dimensions?

PayPal, TCS,

3 41000

Why we use lookup transformations?

 1 5702

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

TCS,

5 17198

Explain about perform recovery?

1 5506

How to recover sessions in concurrent batches?

 1 11079

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

 2 5369

How to recover the standalone session?

 2 8399

What is difference between maplet and reusable transformation?

2 8993

What are the data movement modes in informatcia?

 3 6288

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

 2 6886

Post New Informatica Questions

Un-Answered Questions { Informatica }

explain about unit testing? in real time?

1669

without table how to come first record only in oracle?

1858

What are the restrictions of union transformation?

581

What is meant by incremental aggregation?

587

What are connected or unconnected transformations?

630




explain abt ur project architecture?

1765

Explain pmcmd command usage in informatica

708

What are the designer tools for creating transformations?

685

Define update strategy?

641

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

718

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

731

What is the difference between router and filter?

651

Explain your project of banking domian.

1220

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1412

Why union transformation is an active transformation?

659

For More Un-Answered { Informatica } Questions Click Here