What is Fastly Changing Dimension?
- 6 Answers
- 12388 Views
- TCS, I also Faced
- E-Mail Answers
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 |
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
which dim, fact tables used in bank domain
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
What are the types of hashed files in data stage
What are the different layers in the information server architecture?
what is ds administrator used for?
Define meta stage?
How To find the location of APT_confid file
What are the main features of datastage?
what is the difference between the active datawarehouse and datawarehouse
how will u design file watch jobs?
Teradata 
