Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8234 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 |
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What are iconv and oconv?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
How many jobs in ur project? Explain any complex job u have done in ur project?
how many rows sorted in sort stage by default in server jobs
How to manage date conversion in Datastage?
What are the different type of jobs in datastage?
how to change left and right links in join stage?
what is the difference between the join and look up explin me one exmple
Explain entity, attribute and relationship in datastage?
What are the different options associated with dsjob command?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
Teradata 
