Where we use dynamic lookup and where we use it?do we
generate surrogate keys using dynamic lookup?can we use it
for scd type 2 mapping and why?
- 3 Answers
- 16417 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / nayan naik
Dynamic lookup when used in a SCD-2 implementation ,you must
make sure your lookup transformation is on the target table,
hence the dynamic lookup cache is always in sync.
Surrogate keys are generated using a sequence and not a
lookup transformation. Have a look at this link it gives you
a complete step by step implementation of SCD-2 in informatica.
http://deepinopensource.blogspot.in/2013/03/scd-2-implementations-in-informatica.html
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Can we override a native sql query within informatica?
How would you join a node to the already existing domain?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can informatica be used for an organization?
Please let me know how to make Data masking in informatica..
How can we handle two sessions in informatica?
What are the new features of informatica 9.x at the developer level?
Can we get 1st record through Informatica(without sequence number).
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
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
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Mention few advantages of router transformation over filter transformation.
Explain direct and indirect flat file loading (source file type) - informatica
