what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
Answer Posted / sridhar
if u using star schema to u have to develop the dim tables depends on requirement(like scd1,2,3) then u have to look up on all dim tables using natural keys,when the session time u have to load dim's are sequence process like (s1-s2-s3-s4--eventraise)then all success u can load fact load by using eventwait in concurent manner.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the popular informatica products?
What do think which one is the better joiner or look up?
What is the sql query overwrite in source qualifier in informatica
How to delete duplicate row using informatica?
Differentiate between reusable transformation and mapplet.
How to use procedural logic inside infromatica?
How can repository reports be accessed without sql or other transformations?
Explain the use of aggregator cache file?
wf dont have integration severances how you can run?
What is the way to execute pl/sql script using informatica mapping?
Enlist the differences between database and data warehouse.
Write the unconnected lookup syntax?
How many dimensions are there in informatica?
What the difference is between a database, a data warehouse and a data mart?
What are the various types of transformation?