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 is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?
What are the partitioning techniques available in link partitioner?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3
1 Answers Alpharithm Technologies,
How to initialize environment variables?
project Steps,hits, Project level HArd things,Solved methods?
whats difference between ls -ltr and ls -lrt?
How can one find bugs in job sequence?
i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring
13 Answers Bank Of America, IBM,
What is the sortmerge collector?
What are stage variables and constants?
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????