Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 14076 Views
- Syntel, I also Faced
- E-Mail Answers
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
Can informatica load heterogeneous targets from heterogeneous sources?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How will the document be delivered to me?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
what is the size of your data warehousing?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
design of staging area?
In which transformation you cannot drag ports into it?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Explain the scenario which compels informatica server to reject files?
Mention few power centre client applications with their basic purpose?
How can you validate all mappings in the repository simultaneously?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is different between the data warehouse and data mart?
