What is Fastly Changing Dimension?
Answers were Sorted based on User's Feedback
Answer / vijaya
usually in almost all projects have customer dimension which
is fast growing dimension .
The fast changing dimensions which changes frequently.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / venu
The Entities in the Dimention which are change rapidly is
called Rapidly(fastly) changing dimention. best example is
atm machine transactions
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / prince
Hi Venu, The definition you said for Fastly Changing Dimensions is true, but can you give one more example of a entity that changes frequently. Because ATM transactions will be loaded into FACT TABLE as that is a TRANSACTIONAL DATA but it is not loaded to DIMENSION TABLE.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / janaki ram
Vijaya,
Is this right, i asked fastly changing dimension in DS
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nagam
If a dimension table single attribute or multiple attributes are changing fastly based upon a time is called fast changing dimension table.
Ex:shareholders data in a business
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between sequential file and data set?
What is the difference between Datastage 7.5 and 7.0?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
How to convert RGB Value to Hexadecimal values in datastage?
How many types of views are there in a datastage director?
on how many columns we can perform aggregation in the aggregator stage?
what are the different type of errors in datastage?
Explain the importance of surrogate key in data warehousing?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?