WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE
FIELD
Answer Posted / p.ganesh
SCD 2 TYPE IS USED TO MAINTAIN CURRENT AND HISTORICAL
DATA,FOR THAT I CAN USED LOOKUP,TRANSFORMER,FILTER AND STORE
PROCEDURE STAGES.FOR DATE FIELD WE CAN SELECT THE CURRENT
TIMESTAMP IN FUNTIONS IN THE TRANSFORMER STAGE.
SF--LOOKUP--TRANSFORMER/FILTER1--STOREPROCEDURE--TRANSFOR--TGT
| \FILTER2--STOREPROCEDURE--TRANSFOR--TGT
RDBMS
\FILTER3--TARGER
STOREPROCEDURE IS USED FOR GENERATE THE SID VALUES.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Describe stream connector?
Why we use surrogate key?
project Steps,hits, Project level HArd things,Solved methods?
What is ibm datastage flow designer?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How the ipc stage work?
Define Routines and their types?
How rejected rows are managed in datastage?
How to convert RGB Value to Hexadecimal values in datastage?
Difference between server jobs & parallel jobs?
What are the types of containers?
How do you schedule or monitoring the job?
Can you explain tagbatch restructure operator?
Differentiate between hash file and sequential file?
Why do we use exception activity in Datastage?