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
- 5016 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 can one identify whether mapping is correct or not without connecting session?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the function of aggregator transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to load last n records of file into target table - informatica
How to extract sap data using informatica? What is abap? What are idocs?
Is there any way to read the ms excel datas directly into informatica?
What do you mean by blocking transformation?
Difference between Target-based loading and constraint-based loading?
Differentiate between a repository server and a powerhouse?
What are the static cache and dynamic cache in informatica?
What is persistent lookup cache?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How you prepared reports for OLAP?
