Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
- 3 Answers
- 8078 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / usha
1.Confirmed Dimension:- the dimensions that are bult once
and can be use reused in multiple fact tables
2.Junk Dimension:- the dimension which is used to cerate
junk attributes
3.Degenerated Dimension:- The dimension that are located
in fact table
4.Slowly changing Dimensions:- The dimensions that chaanfes
slowly over a period of time.
Types
SCD type1
SCD type2
SCD type3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
As union transformation gives UNION ALL output, how you will get the UNION output?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How would you join a node to the already existing domain?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Have you worked with/created Parameter file
How do you take back up of repository?
update strategy transformation in informatica
What are the differences between a connected lookup and unconnected lookup?
Explain what is informatica metadata and where is it stored?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Define enterprise data warehousing?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is a snowflake schema?
How do you use reject loader.
What are the components of Informatica? And what is the purpose of each?
