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..
Answer Posted / saikumar
Fact Table: it contains all the transnational Data of the customer
eg: deposited date,withdrawn date etc...
Dimensional Table: it contains non-transnational Data of the customer
eg: c.city,c.loc,c.cname etc.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the areas of application?
How you Implemented SCD Type 1 & Type 2 in your project?
What is the difference between orabulk and bcp stages?
What are the various kinds of the hash file?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is the difference between informatica and datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How can we improve performance of data stage jobs?
State the difference between an operational datastage and a data warehouse?
What is the purpose of pivot stage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the difference types of stages?
How to perform incremental load in datastage?
Explain datastage architecture?
What can we do with datastage director?