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 |
Quickly characterize reusable change?
Whats there in global repository
Can we create a node as a gateway node and the same node can be assigned to a grid?
Can you generate sequence numbers without using the sequence generator transformation?
HOW TO GET THE LATEST DATA IN SCD ?
What is the Difference between SetVariable and setmaxvariable in informatica?
performance tuning of Informatica
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
why we need informatica
What is the difference between informatics 7x and 8x and what is latest version?
When you move from devel to prod how will you retain a variable
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?