task is running successfully but data is not loded why?
Answers were Sorted based on User's Feedback
Answer / bala govi
Either your SQL Override is not reading any records, or
your update stregy is not using the correct condition or
check the task SQL Override and check the properties and
make sure "Enable Test Load" is turned off.
Hope this helps
Bala
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
how to load only the first and last record of a flat file into the target?
What does reusable transformation mean?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
Explain the difference between a data warehouse and a data mart?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
explain about lookup t/r?
Difference between Target-based loading and constraint-based loading?
Do you have knowledge in ralph kimball methodology
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
what is the predefined port in dynamic lookup
When you move from devel to prod how will you retain a variable
difference between repository database and repository service?