ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
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
 Question Submitted By :: Sri
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
Answer
# 1		 
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 ?    2 Yes 0 No
Ranjan
 
  Re: 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
Answer
# 2		 
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 ?    1 Yes 0 No
Abhishek
 
 
 
  Re: 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
Answer
# 3		 
Dimension will be loaded first then fact,
Table size: Dimenstion > fact
Number of Records: fact > dimention
Size: Table < DWH
 
Is This Answer Correct ?    1 Yes 0 No
RajuPatel
[Satyam Computer Services Ltd.]
 
  Re: 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
Answer
# 4		 
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 0 No
Bsgsr
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
what happens if you try to create a shortcut to a non- shared folder?  1
What is the status code?  1
What are the mapings that we use for slowly changing dimension table?  2
how do u tune queries?  1
What are the Advantages of de normalized data?  2
Explain about Recovering sessions?  1
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?  2
What is the difference between procedure and stored procedur? IBM2
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com  1
What is a look up function? What is default transformation for the look up function?  2
What are the types of data that passes between informatica server and stored procedure?  1
what is a time dimension? give an example?  2
What is difference macros and prompts?  1
What is the Difference between DSS & OLTP?  1
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it  1
what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?  1
What is a command that used to run a batch?  2
what are the different types of transformation available in informatica and what are the mostly used ?  1
Howmany ways yoU can update a relational source defintion and what are they?  1
What is data merging,data cleansing,sampling?  1
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com