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

Answers were Sorted based on User's Feedback



iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain.....

Answer / bhargavi

Facts are numeric values (or) daily transactions done to any
business.

Dimensions are detail information about business

E.g.,: cust no,customer name,addr...

Is This Answer Correct ?    4 Yes 0 No

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain.....

Answer / mohammadsadiq

Facts in Banking

Account no


Dimensions in Banking

Branch
Amount

Is This Answer Correct ?    1 Yes 0 No

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain.....

Answer / 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

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain.....

Answer / 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

More Data Stage Interview Questions

What is the process of killing a job in datastage?

0 Answers  


What is a quality stage?

1 Answers  


I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,


What is the differentiate between data file and descriptor file?

0 Answers  


how to validate the jobs

2 Answers   IBM,






How to reverse the string using unix?

0 Answers   CTS,


Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,


Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,


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

0 Answers  


How do u convert the columns to rows in datastage?

0 Answers  


What are transforms and what is the differenece between routines and transforms?

0 Answers  


i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,


Categories