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 ...
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 |
What is native users?
How you count the number of records available at your source?
Major difference between SQL override and Lookup Sql override
Explain transaction control transformation in informatica
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
what is parallel querying and what r hints.
what is mean by complex business rule ?
What is the difference between informatica 8.x and 9.x
Can we get 1st record through Informatica(without sequence number).
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
what is the architecture of any Data warehousing project?
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?