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
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
What are the types of views in datastage director?
Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
What are orabulk and bcp stages?
how to change left and right links in join stage?
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
Why do we use exception activity in Datastage?
Define Merge?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
What is aggtorec restructure operator?