Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 4 Answers
- 8605 Views
- Wipro, I also Faced
- E-Mail Answers
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 is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the use of datastage director?
Differentiate between operational datastage (ods) and data warehouse?
What is a ds designer?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the repository tables in datastage?
Explain Quality stage?
What is the command line function to import and export the ds jobs?
Define data aggregation?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is the difference between datastage and informatica?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
in oracle target stage when we use load option and when we use upsert option?
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
