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
- 8027 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
Define filter transformation?
Different sorts of metadata that stores in the storage facility?
what are the Methods For Creating Reusable Transformations?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is a connected transformation?
What are the uses of etl tools?
What are junk dimensions?
Where do we use mapping variables in informatica?
How will the document be delivered to me?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is the use of code page?
What is target load order?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How to start a workflow using pmcmd command?
