Hai..,This Kiran .
how to immlement SCD's through sequential file.please
explain briefly.if nt ask me i will explain ,what i know.
Answers were Sorted based on User's Feedback
Answer / sindhu
type 1 can be implemented using change capture and change apply stage with sequential files
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ashutosh g
Hi,
SCD means Slowly Changing Dimensions.
There are multiple ways to solve this. However, here are
the three main types:
Type1 : The new record replaces the original record. No
trace of the old record exists.
Type2 : A new record is added into the customer dimension
table with an Active flag or something. Therefore, the
customer is treated essentially as two people. This is the
most popular method.
Type3 : The original record is modified to reflect the
change. Essentially, this method requires adding a new
column to reflect the change. This is very seldom used.
source-->LookupTransform---->transform--->Target DIm
|
Hashfile
Is This Answer Correct ? | 0 Yes | 2 No |
when we will use connected Lookup & Unconnected Lookup
What is APT_DUMP_SCORE?
To see hidden files in LINIX?
what is a message handler
How can you find out whether datastage process is running or not in unix?
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
What is the difference between in process and inter process?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
What are the functionalities of link collector?
Explain connectivity between datastage with datasources?
Differentiate between odbc and drs stage?