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
- 4588 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 |
how will you remove the duplicate records from flat file without using sorter?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
If we set dd_insert in mapping and Delete in session properties what will happen.?
what are challenges that you faced in testing? give solution to it?
How to load last n records of file into target table - informatica
Why we require dwh in particular projects?
What are the new features of informatica 9.x in developer level?
If I have a index defined on target table and if set it to bulk load will it work ?
Explain the etl program with few examples.
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
why we use informatica in our project?
how to sort date field in infomatica?
Teradata 
