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
- 7076 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
Where the datastage stored his repository?
What could be a data source system?
How to manage date conversion in Datastage?
Where do you see different stages in the designer?
How can one find bugs in job sequence?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Enlist various types of routines in datastage.
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Define data aggregation?
What a datastage macro?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Name the command line functions to import and export the DS jobs?
What is usage analysis in datastage?
What are the features of datastage flow designer?
What is a merge?
