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
- 4931 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
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is a snowflake schema?
What are data-driven sessions?
how we can load rejected record's at run time?(not through bad files)
Briefly define reusable transformation?
What is the command used to run a batch?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is enterprise data warehousing?
what are the deliverables?in your project?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the types of presistent cache in look up tr.
Different sorts of metadata that stores in the storage facility?
What are the new features of informatica 9.x at the developer level?
Please let me know how to make encryption and decryption with example?
Please let me know how to make Data masking in informatica..
