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

why dimenstion tables are denormalized in nature ?

3 8474

What is the use of incremental aggregation?

 2 9084

What is the procedure to load the fact table.Give in detail?

 1 8076

what is a junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 58139

What is the difference between Normal load and Bulk load?

 5 48515

Discuss the advantages & Disadvantages of star & snowflake schema?

 5 45043

what is a time dimension? give an example?

IBM,

2 11571

What are the reusable transforamtions?

 1 4347

What is aggregate cache in aggregator transforamtion?

5 8262

What are the basic needs to join two sources in a source qualifier?

 3 6206

In which circumstances that informatica server creates Reject files?

2 9268

Can you copy the session to a different folder or repository?

 2 10751

When the informatica server marks that a batch is failed?

 1 5159

What is a command that used to run a batch?

 2 6499

In a sequential batch can you run the session if previous session fails?

4 9485

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the use of source qualifier?

683

What do you mean by channel change?

555

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

602

What is lookup transformation?

612

What are the popular informatica products?

656




What are the steps involved in the migration from older version to newer version of Informatica Server?

1590

Enterprise data warehouse your projects phase by phase explain?

1478

What is data transformation manager process?

630

In which transformation you cannot drag ports into it?

799

How to implement security measures using repository manager?

612

What is a code page?

727

Differences between connected and unconnected lookup?

618

What is the difference between a connected look up and unconnected lookup?

580

How can we use mapping variables in informatica? Where do we use them?

628

what is the complex transformation you used in informatica

2201

For More Un-Answered { Informatica } Questions Click Here