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 ...

Answer Posted / dharmendra singh

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

761


What do you mean by blocking transformation?

561


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

585


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1715


What does reusable transformation mean?

644






How do you manage the Parameter files while migrating your data from one environment to another environment?

523


What are the conditions needed to improve the performance of informatica aggregator transformation?

553


What is the use of target designer?

581


What is exclusive and normal mode for repository services?

688


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

615


What is a grid in Informatica?

592


What is informatica?

656


Explain sql transformation in script mode examples in informatica

575


What is a passive transformation?

618


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1506