FACT Table:(Daily transaction details) Transaction

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..

Question Posted / subhash

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

Please Help Members By Posting Answers For Below Questions

What is datastage?

1090

Define data aggregation?

1104

How to find value from a column in a dataset?

2207

What is the difference between validated and compiled in the datastage?

1297

What are the various kinds of containers available in datastage?

1048

Can you explain kafka connector?

1314

What are the enhancements made in datastage 7.5 compare with 7.0?

1150

Explain how a source file is populated?

1373

CHANGE CAPTURE

1311

How do you generate sequence number in datastage?

1101

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3799

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3652

What are stage variables, derivations and constants?

1232

Define Job control?

1153

What could be a data source system?

1023