who to split dimentions into sub dimention
- 3 Answers
- 6392 Views
- Wipro, I also Faced
- E-Mail Answers
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 the difference between a shortcut of an object and copy of an object? Compare them.
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
without dynamic lookup how to insert new rows and update existing rows?
Is it possible to use a client with different version than that of its Informatica server?
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
Design a mapping to load the cumulative sum of salaries of employees into target table?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
difference between repository database and repository service?
What is dynamic cache?
What is the commit type if you have a transaction control transformation in the mapping?
Teradata 
