Answer Posted / mohammed
Snowflake is an extension of star schema, where star schema
with each dimension is typically stored in one table.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why do we need informatica?
What is meant by LDAP users?
How do you convert single row from source into three rows into target?
how many types of dimensions are available in informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is meant by a domain?
without table how to come first record only in oracle?
Explain the types of transformations?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How big was your fact table
What is meant by lookup transformation? Explain the types of lookup transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is dimensional table?
What is a transaction control transformation?
What's the layout of parameter file (what does a parameter file contain?)?