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
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
|Is This Answer Correct ?||17 Yes||2 No|
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|
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|
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.
|Is This Answer Correct ?||0 Yes||0 No|
Answer / bsgsr
hi, raju patel.
ur answers are thoughtful. they reflect ur intellect which
is very stimulating and vibrant. i am pretty impressed with
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 email@example.com also provide me your number if you
dont mind. take care
|Is This Answer Correct ?||1 Yes||10 No|
what is mean by grouping of condition column in lookup transformation?
When you move from devel to prod how will you retain a variable
what is parallel querying and what r hints.
Performance tuning in UNIX for informatica mappings?
I have data like sno mailid 1 firstname.lastname@example.org 2 email@example.com 3 firstname.lastname@example.org .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..
Explain the informatica workflow?
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
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Differentiate between a database and data warehouse?
can anyone explain me about retail domain project in informatica?
Do you have to change the reject file b4 using reject loader utility.