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 is the procedure for creating independent data marts from informatica 7.1?
What are the different types of repositories created using informatica?
Enlist some properties of sessions.
What is decode in informatica?
Where can we find the throughput option in informatica?
What is rank index in rank transformation?
How to handle decimal places while importing a flatfile into informatica?
What are the different lookup cache(s)?
What is event and what are the tasks related to it?
write a query to retrieve the latest records from the table sorted by version(scd)
what is INFORMATICA TESTING process
Performance tuning( what you did in performance tuning)
Plz can any one say me how to get the informatica certification materials and dumps
While migrating the data from one environment to another environment how would you manage the connections?
How can we delete duplicate rows from flat files?