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

Why fact table is in normal form?

0 Answers  

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers   HCL,

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

What is lookup table?

5 Answers  

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

2 Answers   Wipro,

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...

5 Answers  

How do u view log file for a particular job?

6 Answers   HP,

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

client know skid info?

0 Answers   NTT Data,

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

What is the use of hoursfromtime() function in transformer stage in datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories