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
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the difference between server job and parallel jobs?
What is a folder? Difference types of stages?
what is ds administrator used for?
Explain how a source file is populated?
What is ds designer?
What is merge stage?
What is the precedence of stage variables,derivations, and constraints?
On which interface you will be working as a developer?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the difference types of stages?
Nls stands for what in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are some prerequisites for datastage?
explain about citrix scheduling tool in datastage