Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6121 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 many datamarts we will use in real time project and when will use the datamart?pls send the replay early
Define oconv () and iconv () functions in datastage?
What is the version control how can i apply this in DataStage can any one tell me the anser
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
Define data aggregation?
Explain Quality stage?
What is the difference between validated and compiled in the datastage?
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?
Teradata 
