how many dimentions and fact tables used in your project and
what are names of it?

Answers were Sorted based on User's Feedback



how many dimentions and fact tables used in your project and what are names of it?..

Answer / raj

Product Dimension : Product Key, Product id, Product Type, Product name, Batch Number.
Distributor Dimension: Distributor key, Distributor Id, Distributor Location,
Customer Dimension : Customer Key, Customer Id, CName, Age, status, Address, Contact
Account Dimension : Account Key, Acct id, acct type, Location, Balance

Is This Answer Correct ?    3 Yes 0 No

how many dimentions and fact tables used in your project and what are names of it?..

Answer / archana

hi raj,
where is the fact tables,can u tell me the fact tables desc also.thanks in advance

Is This Answer Correct ?    0 Yes 0 No

how many dimentions and fact tables used in your project and what are names of it?..

Answer / avinash(datastage proff)

anybody knows it pls send rep fast

Is This Answer Correct ?    3 Yes 6 No

Post New Answer

More Data Stage Interview Questions

How we can covert server job to a parallel job?

0 Answers  


How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,


How rejected rows are managed in datastage?

0 Answers  


which memory is used by lookup and join

5 Answers   IBM,


What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,






im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers  


1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

2 Answers   UHG,


types of errors in datastage?

2 Answers   Reliance,


what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,


What is the difference between odbc and drs stage?

0 Answers  


I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,


when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,


Categories