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
- 13525 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
r u done any partitions in ur project?
What are session parameters ? How do you set them?
What is transformation?
What are the types of data warehouses?
explan ur project architecture?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to join three sources using joiner?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Can informatica load heterogeneous targets from heterogeneous sources?
How many dimensions are there in informatica?
where to store informatica rejected data? How to extract the informatica rejected data?
What is expression transformation?
What is a sorter transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg
