Interested to Buy Any Domain ? << Click Here >> for more details...
How u implement the slowly changing dimensions if my source
table is consisting of cid,cname,add,phno,email but i need to
capture the changes for first three columns how u implement?
- 1 Answers
- 6260 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
This is done by using the Change_Capture_Stage.
In the CDS stage: specify the change key's--> cid and
change_values as cname,add and phone etc
CDC stage triggers the Change_code as 3 if there is any
changes in the cname or add or phone no for the existing cid.
Ex: cid,cname,add,phone,email
1,'vin','bang','08979','vin@Gmail.com'
REf:
cid,cname,add,phone,email
1,'vin','HYD','08979','vin@Gmail.com'
O/P: cid,cname,add,phone,email,Change_code
1,'vin','HYD','08979','vin@Gmail.com',3
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Name the command line functions to import and export the DS jobs?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the features of datastage flow designer?
What are the difference types of stages?
Differentiate between datastage and datastage tx?
What are the types of containers in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the use of datastage director?
Why fact table is in normal form?
Where the datastage stored his repository?
What is use Array size in datastage
Does datastage support slowly changing dimensions ?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are routines in datastage? Enlist various types of routines.
Describe the architecture of datastage?
