If the records doesnt satisfy the filter condition where
will it go?




Answer Posted / ankit kansal

The filtered records will not be written into reject file. Only when data consistency erros or some parsing error occurs, then the records will be move to reject file. In your case PRODUCT_COST value 12 will be filtered out from the mapping flow.


http://deepinopensource.blogspot.com/

Is This Answer Correct ?    0 Yes 0 No






Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

3731


can you please explain me pre session and post session options?

4619


Explain the tuning lookup transformation - informatica

16


what are 3 tech challenges/ common issues you face?

1225


Explain Dataware house architecture .how data flow from intial to end?

1395






waht type of interface is used for testing the data in informatica

1136


How do you handle two sessions in Informatica

9


scenario where i can use only concurrent execution of workflow.

1825


Which transformation is needed while using the Cobol sources as source definitions?

13


Design time, run time. If you don't create parameter what will happen

773


4 yrs etl devloper roles and responsibilities?any body give solutions

878


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

984


Explain about cumulative Sum or moving sum?

13


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

810


Difference between Data and Index Caches?

9