WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO
RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ?
HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND
SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND
EMAIL . PLZ HELP ME ...
Use one more session after your current session which reads
from bad file and load into a flat file.In post session
command of new session you can call a shell script which
checks flat file for non zeror records and send email
accordingley.If record count in flat file is non zero it
should send an email.
| Is This Answer Correct ? | 1 Yes | 2 No |
When to use normalization transformation other than cobol source?
How to improve the session performance in informatica?
what we require for D.modelling?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
Can we get 1st record through Informatica(without sequence number).
Tell me one complex query in oracle ?
what is the significance of newlookup port in dynamic look up
Could any one to tell How to use the Oracle Analytic functions in Informatica?
How to create or import flat file definition in to the warehouse designer?
What is power center repository?
how can u avoid duplicate rows in flat file?
How to extract the informatica rejected data?