In my source i have 10 records but i want 11 records in
target. How can i acheive this in Server jobs.
Answer Posted / satyam
using pivot satage you can get that target records dont bother ok you have to implement that ,otherwise transformer stage in also you can add one record in output colomns and implement thatderivation cell . ok i think it very useful to tour question
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Highlight the main features of datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
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
Notification Activity
What is aggtorec restructure operator?
Can you explain engine tier in information server?
what is use of SDR function?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
in oracle target stage when we use load option and when we use upsert option?
What is a quality stage in datastage tool?
What is job control?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
how to add a new records into source?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...