who to split dimentions into sub dimention

Question Posted / veeru

3 Answers
7478 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

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers CSC,

Can we create out put ports in source qualifier t/r?

5 Answers TCS,

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers Puma,

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers Wipro,

How to eliminate duplicates from flat file..what is the procedure

4 Answers

what is difference between COM & DCOM?

1 Answers Satyam,

Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers IBM,

Can you create a flatfile target

3 Answers ABC,

Enlist some properties of sessions.

0 Answers

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers IBM,

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers

For more Informatica Interview Questions Click Here