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
- 7349 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Facts in Banking
Account no
Dimensions in Banking
Branch
Amount
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
what about data stage requirement
what is the Difference Between Datastage Server Edition and Parallel Edition?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are routines in datastage? Enlist various types of routines.
I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage
what is Audit table?Have u use audit table in ur project?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
difference between server shared container and parallel shared container
To see hidden files in LINIX?
what is the use of skid in reporting?
What is mapping?
Teradata 
