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
- 4 Answers
- 35938 Views
- IBM, Infotech, I also Faced
- E-Mail Answers
Answer Posted / jyoti
Confirmed Dimension: Dimensions which can be used in more
than one subject area.
Better example is : TIME DIMENSION
Junk Dimensions:Which contains Flags,random values comes
under Junk/Dirty dimensions.
Degenerate Dimension:These dimensions are stored in the
Fact table,but these are not Measures.
Slowly chnaging Dimensions:Dimensions which are chnaging
over time .These are Therr types
1) TYPE1: Will not maintain any history
2) Type 2: will maintain current information as well as
history.
3) Type3: will maintain Part history data
| Is This Answer Correct ? | 19 Yes | 8 No |
Post New Answer View All Answers
How to Create a folder using pmrep command?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a node in Informatica?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Slowly changing dimensions, types and where will you use them
In informatics server which files are created during the session rums?
Define joiner transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain the features of connected and unconnected lookup.
list out all the transformations which use cache?
What are the different ways to implement parallel processing in informatica?
Define Pmrep command?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
