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
Reusable transformation and shortcut differences
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Have you worked with/created Parameter file
How to join three sources using joiner? Explain though mapping flow.
What is resilience time?
How we can create indexes after completing the loan process?
What are the types of data warehouses?
Tell me about Propagate functions in informatica
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the advantages of informatica?
What is main use of mapplet?
Explain the mapping variable usage example in informatica
How to Create a folder using pmrep command?
Write the unconnected lookup syntax and how to return more than one column.