Session S1, S2, and S3. In the session S3 I want to load every
Saturday. How it is possible?
- 2 Answers
- 7342 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / anindita
I would change the link condition from S2 --> s3.
I'll format the Sysdate to return 'DAY' and then check if that is equal to Saturday, if that is true link condition is true else false.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Define sessions in informatica etl?
What are roles and groups and benefits of using them?
Write the different tools in the workflow manager?
What is a rank transform?
What are data-driven sessions?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
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
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
how many types of dimensions are available in informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Explain the etl program with few examples.
Define mapping and session?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain what are the different versions of informatica?
