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
- 6325 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
sed,awk,head
What are orabulk and bcp stages?
Explain ibm infosphere information server and highlight its main features?
State the difference between an operational datastage and a data warehouse?
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 ?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What are the repository tables in datastage?
how to add a new records into source?
Can you explain how could anyone drop the index before loading the data in target in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Triggers,VIEW,Procedures
Define project in datastage?
Where do the datastage jobs get stored?
Can you explain kafka connector?
what are the devoleper roles in real time? plz tell i am new to datastage....
