Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rkumar.etl
Unit testing in Informatica performed using ...
1)src qualifier query if providing us the final result
..with only calculating logic in between than ...test the
count results in sql navigator.
2)column to column mapping to make sure the result passing
to columns are correct.
3)data type mismatch or matched.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are active and passive transformations?
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
can u any challenge your project?
What is the use of target designer?
What are the limitations of joiner transformation?
how tokens will generate?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explian the Process of deployment groups in informatica
What are the different transaction levels available in transaction control transformation?
What if the source is a flat-file?
What do you mean by channel change?
How to update a particular record in target with out running whole workflow?
What does “tail –f” command do and what is its use as an Informatica admin.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
