Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do error handling in Informatica?
- 1 Answers
- 8141 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
what is mapping override?
What are the different transaction levels available in transaction control transformation?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Briefly define a session task?
Explain the different lookup methods used in informatica?
What is A cache?
What is a code page?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
How many joins in Informatica
Teradata 
