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
How many types of views are there in a datastage director?
What are the stages in datastage?
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 ?
What is apt_config in datastage?
what is ds administrator used for?
What are the benefits of datastage?
How can you write parallel routines in datastage PX?
how many rows sorted in sort stage by default in server jobs
how to add a new records into source?
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 do u catch bad rows from OCI stage? And what CLI stands for?
What are the various kinds of containers available in datastage?
Differentiate between odbc and drs stage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this