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
- 6042 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 |
what is meta data? Explain? Where it is used?
What are the different database update actions available?
What is the project in datastage?
What is Cleanup Resources and when do you use it?
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
Give an idea of system variables.
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
how to delete one row in target dataset
DataStage Scenario based Interview Questions
Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?
Teradata 
