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
- 8434 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the various kinds of the hash file?
What is oci?
What is the flow of loading data into fact & dimensional tables?
EXPLAIN SCD
What are the types of jobs we have in datastage?
What are the components of ascential data stage?
AGGREGATOR default datatype
What is the difference between datastage and datastage tx?
How to reverse the string using SQL?
Can you define merge?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are transforms and what is the differenece between routines and transforms?
Define APT_CONFIG in Datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Why fact table is in normal form?
