if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact

if i hv 6 table as source table but can i make 12 as a dim
table and 6 as fact table belongs to that src table.

Question Posted / prgn

0 Answers
2248 Views
iGate, I also Faced
E-Mail Answers

No Answer is Posted For this Question
Be the First to Post Answer

More Informatica Interview Questions

What is operational data source (ODS)?

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers Amdocs,

In a sequential batch can you run the session if previous session fails?

4 Answers

Explain in detail about scd type 1 through mapping.

0 Answers

What are the different types of schemas?

11 Answers ITC Infotech,

How big was your fact table

0 Answers

What are the different versions of informatica?

0 Answers

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers Cap Gemini,

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers Cap Gemini, Wipro,

What are the differences between oltp and olap?

0 Answers

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers

For more Informatica Interview Questions Click Here