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
- 4948 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 |
Without source how to insert record to target?
What is an active transformation?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
What is union transformation?
What is mapplet in informatica?
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
Explain grouped cross tab?
What is a shortcut and copy in Informatica and how two are different with each other?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
What is the sequence generator transformation in informatica?
What is an MDDB? What is the difference between MDDBs and RDBMSs?
Teradata 
