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 |
Without source how to insert record to target?
What is lookup change?
Why union transformation is an active transformation?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain informatica architecture - version 8 / 9
what is Partitioning ? where we can use Partition?
Three date formats are there . How to change these three into One format without using expression transformation ?
Separate from an archive server and a powerhouse?
Why should we use star schema in datawarehouse design?
what is session override?
What are the different clients of powercenter?