1.new record it will insert but changes of natural key
is not present in taget i want
to update (here key is composite natural key )can any one
help this to explan how to do
No Answer is Posted For this Question
Be the First to Post Answer
What are the enhancements made in datastage 7.5 compare with 7.0?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
Is the value of staging variable stored temporarily or permanently?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
What is aggtorec restructure operator?
How to remove blank spaces from data?
What is RCP?
How many types of stage?
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2
What are the primary usages of datastage tool?