Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?


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

Post New Answer

More Informatica Interview Questions

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,


What is the difference between stop and abort in informatica

0 Answers   Informatica,


Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  


Which kind of index is preferred in DWH?

3 Answers  


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

0 Answers  






Tell me about informatica architecture.

2 Answers   TCS,


What does role playing dimension mean?

0 Answers  


What are session parameters ? How do you set them?

0 Answers  


in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,


source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,


Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,


Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,


Categories