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 |
Reusable transformation and shortcut differences
What is data movement mode in Informatica and difference between them?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
create a mapping to retrieve the employees who are getting salary greater than average salary?
How you prepared reports for OLAP?
Explain constraint based loading in informatica
where to select code page option?
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
Where is the cache stored in informatica?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
What is a dimensional model?