What is the difference between Junk and Confirmed Dimention?
where can be used htat one in Informatica?
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
Explain informatica architecture - version 8 / 9
What are the types of data warehouses?
which one is better performance wise joiner or look up
What is the Process to creating lookup transformation in informatica
What is dimensional table? Explain the different dimensions.
Differentiate between a database and data warehouse?
What is the reusable transformation?
What are the components of workflow manager?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is status code in informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How big was your fact table
what is the difference between informatica6.1 and infomatica7.1
How to configure mapping in informatica?