I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
Answer Posted / shiva
just truncate table once and run the session again (or)
in session properties just checke the recovery stratagy as
resume from last check point
if i am wrong plese currecct me
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Describe the impact of several join conditions and join order in a joiner transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How to do the error handling of if ur source is flatfiles?
What is difference between a gateway node and worker node?
Briefly explain the aggregator transformation?
What are the designer tools for creating transformations?
What are the new features of Power Center 5.0?
What are the issues you have faced in your project? How did you overcome those issues?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the performance considerations when working with aggregator transformation?
What is the cumulative sum and moving sum?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
draw informatica architecture 8.6 ?
What is informatica metadata and where is it stored?
explain abt ur project architecture?