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
- 5020 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 |
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Write the program through which the records can be updated?
In a concurrent batch if a session fails, can you start again from that session
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is diff between grep and find
How do we call shell scripts from informatica?
Describe an informatica powercenter?
If I have a index defined on target table and if set it to bulk load will it work ?
How do you join more than 3 flat files in informatica?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Teradata 
