plz tell me some dimentional and fact table names in banking
project?
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 |
How do u view log file for a particular job?
What are the steps needed to create a simple basic datastage job?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
how can find maximum salary by using Remove duplicate stage?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
If you want to use the same piece of code in different jobs, how will you achieve it?
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How a routine is called in datastage job?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?