Hai..,This Kiran .
how to immlement SCD's through sequential file.please
explain briefly.if nt ask me i will explain ,what i know.
- 2 Answers
- 5278 Views
- I also Faced
- E-Mail Answers
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 |
hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.
Difference between sequential file and data set?
how many write modes are there in ds
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
How do you load 10 different sources with 10 different layouts to 10 different tables?
What is a datastage job?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Why do we use link partitioner and link collector in datastage?
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
What is the difference between the local container and shared container?
how can u handle null values in transformer stage.
Teradata 
