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
- 5046 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 |
how to get the unique records on multiple columns by using sequential file stage only
What is staging variable?
How to Remove Duplicate using SQL?
1)Source file contains one record, I want 100 records in target file.
Why we need datasets ratherthan sequential files?
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
i want job aborted after some records are loaded into output by using only sequential stage and dataset
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
On which interface you will be working as a developer?
how can u handle null values in transformer stage.
What is RCP?
How to reverse the string using unix?
Teradata 
