Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

why dimenstion tables are denormalized in nature ?

3 6776

What is the use of incremental aggregation?

2 7563

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

1 7151

what is a junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 50983

What is the difference between Normal load and Bulk load?

5 44761

Discuss the advantages & Disadvantages of star & snowflake schema?

5 42341

what is a time dimension? give an example?


2 10032

What are the reusable transforamtions?

1 3416

What is aggregate cache in aggregator transforamtion?

5 6474

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

3 4856

In which circumstances that informatica server creates Reject files?

2 8072

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

2 9663

When the informatica server marks that a batch is failed?

1 4297

What is a command that used to run a batch?

2 5298

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

4 7801

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are some examples of informatica etl programs?


What is a connected transformation?


design of staging area?


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?


How to call shell scripts from informatica?


Explain load alternative records / rows into multiple targets - informatica


What are the conditions needed to improve the performance of informatica aggregator transformation?


Target increases every day even though no new record was inserted


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


Explain the informatica workflow?


Parameter and variable differences


How does the aggregator transformation handle null values?


hi real timers . iam waiting for ur reply regarding ETL TESTING


What is powercenter on grid?


Explain the different kinds of facts.