Follow Our FB Page << CircleMedia.in >> 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?

IBM,

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?

145


What is a connected transformation?

201


design of staging area?

1086


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

4507


How to call shell scripts from informatica?

154






Explain load alternative records / rows into multiple targets - informatica

198


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

168


Target increases every day even though no new record was inserted

529


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

137


Explain the informatica workflow?

144


Parameter and variable differences

1148


How does the aggregator transformation handle null values?

152


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

1253


What is powercenter on grid?

151


Explain the different kinds of facts.

136