How to LOG 'unmatched Master' records and 'Reject Updates' in log files using MERGE stage?
Answer / 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 |
What are the important features of datastage?
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
why we use hash file for lookup?
What are the types of containers and how to create them?
if ename='subbu' while running job the job should be abort how come?
I have a few records just I want to store each records tow times in target how?
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
when u face critical situation in ur project, how to solve them?
what is the main differences between Lookup, Join and Merge stages?
What are the types of jobs we have in datastage?