Interested to Buy Any Domain ? << Click Here >> for more details...
what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
- 3 Answers
- 7152 Views
- I also Faced
- E-Mail Answers
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 DR strategy for Informatica project?
Informatica settings are available in which file?
What is the sql query overwrite in source qualifier in informatica
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is intricate mapping?
How do you load only null records into target? Explain through mapping flow.
What is InformaticaPowerCenter?
What do you mean incremental aggregation?
What is the command used to run a batch?
What are the features of complex mapping?
differences between service based and product based?
have u done any performance tuning? how u ll do?
What is confirmed fact in dataware housing?
What is source qualifier transformation in informatica?
Explain what are the different types of transformation available in informatica.
