Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / deepa
star schema has fact table in the middle and dimensions
around it which are denormalized.
normalized form of star schema is called snow flake star
schema.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to generate sequence numbers?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is workflow monitor?
What is the procedure for creating independent data marts from informatica 7.1?
list out all the transformations which use cache?
What is different between the data warehouse and data mart?
What is meant by incremental aggregation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How are indexes created after completing the load process?
What happens when a session fails and you click on recover?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the different lookup cache(s)?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
update strategy transformation in informatica
