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


Please Help Members By Posting Answers For Below Questions

Differentiate between hash file and sequential file?

592


What is the difference between operational data stage (ods) and data warehouse?

685


What is apt_config in datastage?

715


Why fact table is in normal form?

690


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1905






How do you import and export the datastage jobs?

745


Whats difference betweeen operational data stage (ods) and data warehouse?

677


What are the steps required to kill the job in Datastage?

695


Difference between server jobs & parallel jobs?

658


If you want to use the same piece of code in different jobs, how will you achieve it?

650


Differentiate between Join, Merge and Lookup stage?

656


what is ds administrator used for?

732


Difference between data warehousing and olap?

659


project Steps,hits, Project level HArd things,Solved methods?

1641


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 ?

1640