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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different plug-ins stages used in your projects?

630


Where do the datastage jobs get stored?

737


I have a few records just I want to store data in to targets cycling way how?

1907


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2088


Define Routines and their types?

628






Differentiate between validated and Compiled in the Datastage?

654


How can we improve performance of data stage jobs?

620


Define meta stage?

790


What is a datastage job?

625


Differentiate between odbc and drs stage?

598


What are the types of containers in datastage?

707


What is the roundrobin collector?

645


What is the difference between hashfile and sequential file?

729


How do you schedule or monitoring the job?

677


Describe the architecture of datastage?

576