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 8431

What is the use of incremental aggregation?

 2 9040

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

 1 8060

what is a junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 57999

What is the difference between Normal load and Bulk load?

 5 48445

Discuss the advantages & Disadvantages of star & snowflake schema?

 5 44991

what is a time dimension? give an example?

IBM,

2 11542

What are the reusable transforamtions?

 1 4324

What is aggregate cache in aggregator transforamtion?

5 8217

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

 3 6180

In which circumstances that informatica server creates Reject files?

2 9227

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

 2 10718

When the informatica server marks that a batch is failed?

 1 5135

What is a command that used to run a batch?

 2 6463

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

4 9454

Post New Informatica Questions

Un-Answered Questions { Informatica }

Difference between Target-based loading and constraint-based loading?

548

Explain the use of aggregator cache file?

669

How might you approve all mappings in the archive all the while?

598

What is rank transformation in informatica

687

Explain the shared cache and re-cache?

608




Is it possible to revert a global repository to local one and why?

608

Quickly characterize reusable change?

685

Define filter transformation?

619

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1864

How can you differentiate between powercenter and power map?

619

Why is sorter an active transformation?

659

what is the size of u r source(like file or table)?

1812

What is the need of etl tools?

603

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1740

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1695

For More Un-Answered { Informatica } Questions Click Here