Answer Posted / rajeshkumar
A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts. Date is a common conformed dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning when joined to any fact table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is a difference between complete, stop and abort?
What is an active transformation?
What is the status code in stored procedure transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Differences between version 7.x and 8.x.
How many transformations can be used in mapplets.
What is the difference between router and filter?
Plz can any one say me how to get the informatica certification materials and dumps
Which is the t/r that builts only single cache memory?
What are ETL Tools?
How to use procedural logic inside infromatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Differentiate between a repository server and a powerhouse?