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
What are the types of containers?
what is flow of project?
Difference between server jobs & parallel jobs?
Enlist various types of routines in datastage.
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.
How to reverse the string using unix?
What is meta stage?
What a datastage macro?
What is the use of datastage designer?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Can you implement SCD2 using join, transformer and funnel stage?
What are the primary usages of datastage tool?
How to Remove Duplicate using SQL?
what is the difference between == and eq in UNIX shell scripting?