Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srikanth nallapati
star schema is a centrelized fact table surrounded by
dimention tables.where dimention tables are denormalized .
here the number of joins are less then the query
performence good.
but in snow flake schema dimention tables are normalized
here we can view lowest level granularity .here the number
of joins are high comparing to snowelake schema then
automatically performence is degread.
Note:performence is depending upon the requirement
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Have you worked with/created Parameter file
where to store informatica rejected data? How to extract the informatica rejected data?
Does an informatica transformation support only aggregate expressions?
Partition, what happens if the specified key range is shorter and longer
What is union transformation in informatica?
Can you use flat files in Mapplets.
What is a standalone command task?
Explain pmcmd command usage in informatica
What is event and what are the tasks related to it?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is intricate mapping?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
can we override a native sql query within informatica? Where do we do it? How do we do it?
lookup transformation with screenshots
