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
- 4871 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
What are the types of lookup transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Can you use flat files in Mapplets.
Explain what transformation and how many are there in informatica?
What are the advantages of informatica?
What is decode in informatica?
What is update strategy transform?
What are the new features of informatica 9.x in developer level?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
4 yrs etl devloper roles and responsibilities?any body give solutions
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain sessions?
difference between informatica 8.1.1 and 8.6
