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

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  


Define orabulk and bcp stages?

0 Answers  


Can you explain kafka connector?

0 Answers  


Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  


How many areas for files does datastage have?

0 Answers  






What is the difference between orabulk and bcp stages?

0 Answers  


diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,


Can you explain tagbatch restructure operator?

0 Answers  


how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,


How do u convert the columns to rows in datastage?

0 Answers  


source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,


how to handle null values in sequential file?

1 Answers   HCL,


Categories