What are Rapid changing dimensions?
- 1 Answers
- 4639 Views
- I also Faced
- E-Mail Answers
Answer / arun
A dimension which have frequent changes. These type of dimensions can be maintained by splitting up the frequently changing attributes in to sub dimensions (More like a Normalized structure), so history can be maintained with less storage. But retrieval may be time consuming.
| Is This Answer Correct ? | 2 Yes | 0 No |
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales
3 Answers Cognizant, Flextronics,
What does role playing dimension mean?
Explain the etl program with few examples.
What are the different types of code pages available in informatica & how to implement it in your project?
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What is difference between a connected look up and unconnected look up?
What are the different types of Type2 dimension maping?
How to view and Generate Metadata Reports?
difference between source based commit? and target based commit? which is better with respect to performance?
Teradata 
