Interested to Buy Any Domain ? << Click Here >> for more details...
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 ...
- 1 Answers
- 4936 Views
- I also Faced
- E-Mail Answers
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 is a joiner transformation and why it is an active one?
What is the difference between Active and Passive transformation?
What is the use of code page?
What are the different transaction levels available in transaction control transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
what is the hint? how to use it to reduce the query processing in program?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Performance tuning in UNIX for informatica mappings?
What is a stored procedure transformation?
How to Create a folder using pmrep command?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the use of target designer?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain the types of lookup transformation?
Target increases every day even though no new record was inserted
