if i hv 6 table as source table but can i make 12 as a dim
table and 6 as fact table belongs to that src table.
- 1 Answers
- 2301 Views
- iGate, I also Faced
- E-Mail Answers
Answer / Chetan Jaiswal
It is technically possible to create more dimension (dim) tables than the number of source tables, but it depends on the data relationships and granularity you're trying to achieve. You can aggregate or normalize your data across multiple fact tables while maintaining relevant dimensions. However, be mindful of data redundancy and complexity when designing your data model.
| Is This Answer Correct ? | 0 Yes | 0 No |
how can we use sorter transformation in joins?
How do you implement configuration management in Informatica?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
What are the different components of powercenter?
How can i send first half of the records to one target and Remaining to other target?
What is InformaticaPowerCenter?
Why filter transformation is an active one?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
What are the associated ports in look up T/R.
What are the steps involved in the migration from older version to newer version of Informatica Server?
Is snow flake or star schema used? If star schema means why?
Teradata 
