whats the logic to load the lower level of granularity of
data to fact table.


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

Post New Answer

More Informatica Interview Questions

what is the use of Data Mart?

5 Answers   IBM,


What is substr in informatica?

0 Answers  


What are active transformations.

0 Answers  


write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  


how do u tune queries?

1 Answers  






Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,


What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


what are presession,postsession success and postsession failure commands ?

1 Answers  


whatis the default data driven operation in informatica

2 Answers  


1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,


Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,


in which situations do u go for starflake schema ?

6 Answers   TCS,


Categories