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
- 8232 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
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is quality stage?
how do u catch bad rows from OCI stage? And what CLI stands for?
How do you run datastage job from the command line?
What are the repository tables in datastage?
What is ds designer?
What are routines in datastage? Enlist various types of routines.
Difference between in process and inter process?
What is the method of removing duplicates, without the remove duplicate stage?
how to export or import the jobs in .ISX file
What is the differentiate between data file and descriptor file?
table actions available in oracle connector?
How will you move hashed file from one location to another location?
What are the types of containers?
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.
