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
draw informatica architecture 8.6 ?
can u any challenge your project?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the components of workflow manager?
how tokens will generate?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what are the Methods For Creating Reusable Transformations?
Explain the difference between mapping parameter and mapping variable?
How to join three sources using joiner?
What are the new features of informatica 9.x at the developer level?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is the difference between a connected look up and unconnected lookup?
what are 3 tech challenges/ common issues you face?
Explain the different kinds of facts.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process