I am running a job with 1000 records.. If the job gots
aborted after loading 400 records into target... In this
case i want to load the records in the target with 401
record... How will we do it??? This scenario is not for
sequence job it's only in the job Ex: Seq file--> Trans-->
Dataset..
Answer Posted / sree
by using look-up stage we can get the answer..
there are two tables like 1000 records(source) table and 400
records(target) table.
take the source table as primary table and 400 records table
as reference table to look-up table
reference table
.
.
.
source............. look-up......... target
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
If you want to use a same piece of code in different jobs, how will you achieve this?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What a datastage macro?
What is active and passive stage?
Can you explain players in datastage?
What is "fatal error/rdbms code 3996" error?
What are orabulk and bcp stages?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the different common services in datastage?
What is orabulk stage?
What are the stages in datastage?
What all the types of jobs you developed?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
sed,awk,head