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
- 8442 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
how to add a new records into source?
What are the types of containers in datastage?
How do you register plug-ins?
Name the different sorting methods in datastage.
On which Dimension Table you implemented SCD Type in your Project
What could be a data source system?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Describe link sort?
Differentiate between datastage and informatica?
What is difference between join, merge and lookup stage?
What are the functionalities of link partitioner?
Lookup constraints
Define data aggregation?
What is the sortmerge collector?
How can we improve performance of data stage jobs?
