Can anyone please help me out,In which transformations records
will be rejected and how capture those records?and How to
reload the rejected records?
Answer Posted / sreedhar lokaray
There is no such transformation which can handle reject
records. In reconciliation and validation process we
generally reject the records upon not meeting certain
criteria and load them into error log (files or tables).
These logs are later verified and the rejected records are
reloaded after making corrections.
As a simple example if we define the criteria that an
employee record where salary =0 or null should not be
loaded into the target table will be routed to the reject
table/error log using a router transformation.
Hope this clears your question.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is index?how it can work in informatica
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
What do you mean by blocking transformation?
Explain constraint based loading in informatica
What are some examples of informatica etl programs?
how tokens will generate?
Where is metadata stored?
What is update strategy transform?
What are the tasks that source qualifier perform?
Difference between Target-based loading and constraint-based loading?
What are the tasks that can be performed using sq?
tell me the rules and responsblites in our project(my project is development)
What is xml source qualifier transformation in informatica?
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
What is a rank transform?