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
- 5995 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define repository tables in datastage?
What are stage variables and constants?
Define Routines and their types?
How to Remove Duplicate using SQL?
How many types of hash files are there?
What are the types of views in datastage director?
Differentiate between hash file and sequential file?
What are the areas of application?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Explain how a source file is populated?
Why do you need stage variables?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is size of a transaction and an array means in a datastage?
Which warehouse using in your datawarehouse
Difference between in process and inter process?
