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

  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 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

For More Un-Answered { Informatica } Questions Click Here