What are Rapid changing dimensions?
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 |
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this
How to display First letter of Names in Caps?
what is the complex transformation you used in informatica
 Code page compatibly –Where all changes are made to handle the scenario.
How to find from a source which has 10,000 records, find the average between 500th to 600th record?
What is confirmed dimension and fact?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain what are the different types of transformation available in informatica.
On which transformations you created partitions in your project?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
what is galaxy repository?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?