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 |
What are the main features of datastage?
What is RCP
Can you explain how could anyone drop the index before loading the data in target in datastage?
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
What is the flow of loading data into fact & dimensional tables?
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
how to find out number of records imported into source file?
In merge stage can we update the values?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..