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 |
what is mystery dimension?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How can u stop a batch?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
How to extract the informatica rejected data?
complex mapping ur project u r invlve can u explain and give real time example give me ?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
What are the differences between joiner transformation and source qualifier transformation?
wat are deployement groups in informatica, how it will be used for developers
How many repositories can we create in Informatica?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records