Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse




Answers were Sorted based on User's Feedback



Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / ranjan

it depends upon the requirement of the client . dimension
table is loaded first , using the primary keys of the
dimension table , fact tables are loaded .size of the fact
and dimension table also depends upon the requirement .
size of the table and warehouse also depends upon clients
requirement .

Is This Answer Correct ?    17 Yes 2 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / abhishek

ranjan is right its all depend on that how many years old
data u are going to keep in your warehouse
first dimension will load and then on base of dimension we
load fact table

Is This Answer Correct ?    10 Yes 0 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / rajupatel

Dimension will be loaded first then fact,
Table size: Dimenstion > fact
Number of Records: fact > dimention
Size: Table < DWH

Is This Answer Correct ?    10 Yes 1 No




Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / dhana

Can anyone please tell me the No. of Fact table & Dimension tables usually used in a prjoect?I just need an example.Also the size of data warehouse?Is it in Terabyte of something?I just need an approximate size.
Thanks

Is This Answer Correct ?    0 Yes 0 No

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is lo..

Answer / bsgsr

hi, raju patel.

ur answers are thoughtful. they reflect ur intellect which
is very stimulating and vibrant. i am pretty impressed with
your answers.

i believe you have good experience with the industry. since
when have you been working with the industry. can i have
some of my queries cleared only if you dont
minddddddddddddddddd!!!!!!!!!!!!. revert back to me on my
id bsgsr12@gmail.com also provide me your number if you
dont mind. take care

Is This Answer Correct ?    1 Yes 10 No

Post New Answer



More Informatica Interview Questions

what is mean by grouping of condition column in lookup transformation?

1 Answers  


When you move from devel to prod how will you retain a variable

1 Answers  


what is parallel querying and what r hints.

1 Answers  


Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,


I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,






Explain the informatica workflow?

0 Answers  


Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500

0 Answers   Cap Gemini,


1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,


Differentiate between a database and data warehouse?

0 Answers  


can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,


Do you have to change the reject file b4 using reject loader utility.

1 Answers  






Categories