Answer Posted / 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 |
Post New Answer View All Answers
How can informatica be used for an organization?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
what is the Default Source Option For Update Strategy Transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How many types of sessions are there in informatica.please explain them?
What is pmcmd command?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the different types of olap? Give an example?
How we can use union transformation?
What is informatica?
What differs when we choose the sorted input for aggregator transformation?
Whats there in global repository
What is dimensional table? Explain the different dimensions.
How many transformations can be used in mapplets.