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 |
What is the difference between view and materialised view?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
in which situations do u go for scds ?
What is the need of an ETL tool?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are pre and post-session shell commands?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
What is domain in terms of informatica?
Which is the best place to learn Informatica Powercenter Online Training?
How union transformation is used?