Tell me how many tables used in Ur project and how many fact
tables and dimension tables
used in ur project

Answers were Sorted based on User's Feedback



Tell me how many tables used in Ur project and how many fact tables and dimension tables used in u..

Answer / davankumar

Actuvally...that can be dependinge ur project...but u have
2 say like these..In my project we have more than 100
tables but in my module we can used only 10 to 15 tables
only..
Then dimension :5 to 6 dimension tables
And 1 or 2 fact tables

Is This Answer Correct ?    4 Yes 0 No

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in u..

Answer / davankumar

Actuvally...that can be dependinge ur project...but u have
2 say like these..In my project we have more than 100
tables but in my module we can used only 10 to 15 tables
only..
Then dimension :5 to 6 dimension tables
And 1 or 2 fact tables

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,


100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,


How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,


how DTM buffer size and buffer block size are related

3 Answers   Wipro,


Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,






i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,


How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,


What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,


In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,


What is an expression transformation?

0 Answers  


Categories