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
- 4374 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
How do you update the records with or without using update strategy?
What do you mean by filter transformation?
How do you load unique records into one target table and duplicate records into a different target table?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain transaction control transformation in informatica
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Sequence generator, when you move from develoment to production how will you reset
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is InformaticaPowerCenter?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are active and passive transformations?
What are the designer tools for creating transformations?
Differences between connected and unconnected lookup?
Briefly define reusable transformation?
what are 3 tech challenges/ common issues you face?
