If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING..
CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE
RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
Answer Posted / babu
yes, u can see the out put in single run,
in mappings tab one option is there, that is TARGET LOAD
ORDER.
if any thing is wrong please let me know.
Cheers,
babu
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the various types of transformation?
What is pmcmd command?
Briefly define reusable transformation?
Enlist the differences between database and data warehouse.
What does update strategy mean, and what are the different option of it?
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
What is the difference between router and filter?
What is powercenter on grid?
what is the difference between informatica6.1 and infomatica7.1
What is status code in informatica?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Informatica Checkpoints
Explain how many types of dimensions are available in informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How we can create indexes after completing the loan process?