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
- 5908 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
Lookup constraints
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is oci?
Define project in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
how to write server Routine coding?
What is the difference between account and directory options ?
which r the connectors used in san?
How do you generate sequence number in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is the command line function to import and export the ds jobs?
Nls stands for what in datastage?
What are the components of datastage?
