Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kishore
Mainly errors were like null values first we need to process error records into one target and good record into another target by using router transformation.after execution of mapping we check the error file size through unix if error file size is greater than 0 then we will send email to source system team with error file attachments.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Do you find any difficulty while working with flat files as source and target?
What are the different lookup cache(s)?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the types of schemas we have in data warehouse.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What does update strategy mean, and what are the different option of it?
What does command task mean?
Differentiate between sessions and batches?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is native users?
Differentiate between Load Manager and DTM?
Make a note of the quantity vaults made in informatica?
How to convert multiple rows to single row (multiple columns) in informatica
How many types of sessions are there in informatica.please explain them?
