Target is zero file and how can you send the email?
Answer Posted / gazulas
hmm...
session---------->email_task
in the link write a condition "if tgtsuccessrows < 1"
automatically an email will be kicked off...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
Why union transformation is an active transformation?
How identifying bottlenecks in various components of informatica and resolving them?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
How might one distinguish in the case of mapping is right or not without associating session?
server hot-ws270 is connect to Repository B. What does it mean?
What do you mean by filter transformation?
What are the main features of Oracle 8i with context to datawarehouse?
What is the commit type if you have a transaction control transformation in the mapping?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Differentiate between sessions and batches?
What are the different components of powercenter?
where to store informatica rejected data?
What is aggregator transformation in informatica?
What is intricate mapping?