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
- 5033 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
If you want to use a same piece of code in different jobs, how will you achieve this?
What are iconv and oconv?
what is flow of project?
On which Dimension Table you implemented SCD Type in your Project
how to sort two columns in single job in datastage.
What is the differentiate between data file and descriptor file?
whom do you report?
Define data aggregation?
What is merge stage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What are the functionalities of link partitioner?
What are the components of datastage?
what are the devoleper roles in real time? plz tell i am new to datastage....
How to implement complex jobs in data stage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
