Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

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

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers  

How many Nodes configuration file you used in your last project?

1 Answers  

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,

how to sort two columns in single job in datastage.

1 Answers   TCS,

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

What are the functionalities of link collector?

0 Answers  

How to display errors in datastage?

1 Answers   TCS,

What are the benefits of datastage?

0 Answers  

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

what is data mapping

2 Answers  

convert yyyy mm dd to dd mm yyyy?

4 Answers  

source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?

2 Answers   Wipro,

For more Data Stage Interview Questions Click Here
Categories