task is running successfully but data is not loded why?
Answer Posted / krishnakanth.ch
There could be many possibilites:
1) Data are getting rejected due to primary key violation
2) The conditions given in filter or router or update are
satisfying.
3) Make sure 'Enable Test load' option is not enabled.
4) Check for any post sql override in the session
Properties.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
In development project what is the process to follow for an etl developer from day1
Why do we need informatica?
What is the difference between informatics 7x and 8x and what is latest version?
What is dimensional table?
Mention a few design and development best practices for informatica?
Why union transformation is an active transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Explain constraint based loading in informatica
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 to join three sources using joiner?
what is INFORMATICA TESTING process
Can we change Dynamic to Static or Persistent cache? If so what happens?
What's the layout of parameter file (what does a parameter file contain?)?
can we override a native sql query within informatica? How do we do it?
What does cheating measurement mean?