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
- 4853 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 the difference between informatics 7x and 8x and what is latest version?
How is union transformation utilized?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the different types of transformation available in informatica.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How many types of sessions are there in informatica.please explain them?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is confirmed fact in dataware housing?
difference between repository database and repository service?
can u any challenge your project?
What is dynamic cache?
What is decode in informatica?
can u give example for factless fact table
What does reusable transformation mean?
have u done any performance tuning? how u ll do?
