plz tell me some dimentional and fact table names in banking
project?
- 2 Answers
- 9101 Views
- Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sivaprasad
DimAgreementStatus,
DimCalendarDate
DimDBANAME
FACTMOPOLICYRELATIONPRO
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / dev
dim- ACCOUNT ,BRANCH,CALENDAR,FOUND TRANS
FACT- DetailsFact,DAILYAGGREATFACT
| Is This Answer Correct ? | 0 Yes | 0 No |
what is mapping lookup
what is use of SDR function?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
Differentiate between data file and descriptor file?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
What is the difference between account and directory options ?
what is set mapping in datastage??
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
What are the processing stages?
Teradata 
