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
If you want to use the same piece of code in different jobs, how will you achieve it?
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
What a datastage macro?
Differentiate between datastage and datastage tx?
why do u need the IOS upgradation in a FC switch
What is the difference between hashfile and sequential file?
What is difference between join, merge and lookup stage?
Differentiate between datastage and informatica?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are the different layers in the information server architecture?
Difference between in process and inter process?
What are the main features of datastage?
Have you used Unstructured data?