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
- 4634 Views
- I also Faced
- E-Mail Answers
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 |
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
How to load a Dimension ? and how to load a fact table?
Why we use ENABLE HIGH PRECISION in session properties?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
In how many ways we can create ports?
how we can load rejected record's at run time?(not through bad files)
What are the circumstances that infromatica server results an unreciverable session?
what is update strategy transformation ?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
Is snow flake or star schema used? If star schema means why?
How are parameters defined in informatica?
Teradata 
