How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
Answer Posted / subbuchamala
by setting below option in MERGE stage, we can log 'unmatched Master' records and 'Reject Updates' in log files:
1. Warn on Rejected Updates=TRUE
--->True to generate a warning when bad records from any update links are rejected.
2. Warn on Unmatched Masters=TRUE.
--->True to generate a warning when there are unmatched rows from the master link.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How do you schedule or monitoring the job?
What are data elements?
How many Key we can define in remove duplicate stage?
What are the different plug-ins stages used in your projects?
EXPLAIN SCD
Distinguish between informatica & datastage. Which one would you choose and why?
Describe link sort?
Define project in datastage?
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
Terminate Activity
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the types of containers in datastage?
Where the datastage stored his repository?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)