How do you do error handling in Informatica?
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 |
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
why we r using presql&postsql in source qualifier?
what are types of dimentions?
is it possible to index the data in cache of lkp transformation ?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
What are the main features of Oracle 8i with context to datawarehouse?
how can we check whether a particular cache is static or dynamic?
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are mapplets?
What is query panel?
what are the unix commands to start the wrk flow ?