who to split dimentions into sub dimention
Answers were Sorted based on User's Feedback
Answer / srinu
make required column as primary-forign key relation then add
fields wt do u want
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vino
i Think,
You can split the dimension tables into two and can join
the two separate dimemsion tables by the surrogate key.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kittu
It is clearly apt for snowflake schema because in snow flake schema dimension table are further splits the de-normalized table into small normalized dimensions to decrease the table space and also to increase the performance this can be done with help on foreign key and primary key constraints
Is This Answer Correct ? | 0 Yes | 0 No |
how many data models u have done in informatica project?
what is datamart
How to generate sequence numbers without using the sequence generator transformation?
In any project how many mappings they will use(minimum)?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
how the server recognises , if the session fails after loading the 100 records in to the target
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
How to extract sap data using informatica? What is abap? What are idocs?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Informatica settings are available in which file?
What do you mean by filter transformation?
How many repositories can be created in informatica?