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


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

Post New Answer

More Informatica Interview Questions

Sequence generator, when you move from develoment to production how will you reset

0 Answers  


how do u move the code from development to production?

6 Answers  


What is degenerated dimention table?

7 Answers   Patni,


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  


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,






explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  


What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  


can we use bulk loading when we use look in mapping

1 Answers   TCS,


what is the use of Data Mart?

5 Answers   IBM,


Write the program through which the records can be updated?

0 Answers  


Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,


Categories