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
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?
What do you mean by blocking transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
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 ?
What does reusable transformation mean?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the use of target designer?
What is exclusive and normal mode for repository services?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is a grid in Informatica?
What is informatica?
Explain sql transformation in script mode examples in informatica
What is a passive transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?