how many dimentions and fact tables used in your project and
what are names of it?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / avinash(datastage proff)
anybody knows it pls send rep fast
| Is This Answer Correct ? | 3 Yes | 6 No |
if ename='subbu' while running job the job should be abort how come?
In which situations we can use normal and sparse lookup stages
What are stage variables, derivations and constants?
Does datastage support slowly changing dimensions ?
in oracle target stage when we use load option and when we use upsert option?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
Difference between the Sequence and Sequencer in DS?
What are orabulk and bcp stages?
Name the different sorting methods in datastage.
what are fact tables and dimension tables? give example assuming one table.
What is datastage?