who to split dimentions into sub dimention

Question Posted / veeru

3 Answers
7493 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

who to split dimentions into sub dimention..

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

who to split dimentions into sub dimention..

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

who to split dimentions into sub dimention..

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

Post New Answer

More Informatica Interview Questions

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers Accenture, HCL,

what is row level and column level indicator?

1 Answers TCS,

How many transformations can be used in mapplets.

0 Answers

what is metadata?

6 Answers

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers Oracle,

select count(1) from emp? what is the o/p?

5 Answers TCS,

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers Cognizant, HCL,

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers Span Systems,

replace multiple spaces with single space.

3 Answers IBM,

For more Informatica Interview Questions Click Here