Interested to Buy Any Domain ? << Click Here >> for more details...
By seeing the parameter file how do u identify wheather it
is a workflow parameter or mapping parameter?
- 5 Answers
- 8945 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / rakesh
Variables which has "$$" as prefix are the Mapping variables.
Variables which has "$" as prefix are the Session variables.
Variables which has "$$$" as prefix are the system defined variables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How are the sources and targets definitions imported in informatica designer?
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 granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
State the differences between sql override and lookup override?
What is session task and command task?
Slowly changing dimensions, types and where will you use them
How can you increase the performance in joiner transformation?
What is depict expression change?
How to create or import flat file definition in to the warehouse designer?
What are the types of data warehouses?
What are the advantages of informatica?
what is the -ve test case in your project.
Informatica Checkpoints
Quickly characterize reusable change?
Explain about cumulative Sum or moving sum?
