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

Can you filter data in hashed file?

0 Answers  


Define APT_CONFIG in Datastage?

0 Answers  


What is active and passive stage?

0 Answers  


Why fact table is in normal form?

0 Answers  


How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,






What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?

1 Answers  


How do y read Sequential file from job control?

2 Answers   IBM, Telesis, HP,


3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  


1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,


How to clean the datastage repository?

0 Answers  


On which Dimension Table you implemented SCD Type in your Project

0 Answers  


souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  






Categories