What is the difference between Junk and Confirmed Dimention?
where can be used htat one in Informatica?
- 3 Answers
- 7976 Views
- I also Faced
- E-Mail Answers
Answer Posted / sarvesh
merge two or more dimensional tables which are having the
low cardinality colomns into a single table is known
as "junk dimensional tables,
two or more fcat tables can be shared with a single
dimensional table is known as "conformed dimension"
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is powercenter on grid?
What is the need of etl tools?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a transaction control transformation?
explain about unit testing? in real time?
Quickly characterize reusable change?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to generate or load values in to the target table based on a column value using informatica etl tool.
In warehouses how many schemas are there?
Can you use flat files in Mapplets.
Differentiate between a database and data warehouse?
What is complex mapping?
