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 types of jobs we have in datastage?
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
job locking methods? How can we unlock the job?
1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.
What are the types of containers in datastage?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
what is a nodemap constraint
what are the devoleper roles in real time? plz tell i am new to datastage....
How do u convert the columns to rows in datastage?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?