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
- 5089 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 active and passive transformations?
What is rank index in rank transformation?
What are different types of transformations available in informatica?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
Explain the shared cache and re-cache?
how we do performence tuning in informatica
what is the complex transformation you used in informatica
What is A cache?
what is mean by flag 4 in update strategy t/r
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
Suppose we do not group by on any ports of the aggregator what will be the output?
Teradata 
