What is a dimensional model?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

what is the process of target load planing?

2 Answers   IBM,


Can we update the data in flat file using update strategy?

3 Answers  


How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  


How to load query faster,so that It will take less time to load?

1 Answers   BNP Paribas,


Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,






my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  


I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  


how to load rows into fact table in data warehouse

0 Answers   Informatica,


How are parameters defined in informatica?

3 Answers   HP, TCS,


What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


Describe data concatenation?

0 Answers  


Categories