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
- 7028 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / subhash
FACT Table:(Daily transaction details)
Transaction_Details
Dimension Tables:(Which have static data)
Customer_details
Account_Details
DATE & TIME
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Is it possible to query a hash file?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Can you filter data in hashed file?
What are the differences between datastage and informatica?
What is the difference between passive stage and active stage?
What is the precedence of stage variables,derivations, and constraints?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Why do we use exception activity in Datastage?
How and where you used hash file?
How a source file is populated?
What a datastage macro?
Define data aggregation?
What are the different types of lookups in datastage?
Name the different types of Lookups in Datastage?
How to perform incremental load in datastage?
