i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4
session after 5th session how will you do?
Answer Posted / omkar
first s1, s2, s3, s4 are run at parallel mode, and these 4
sessions are conncet to s5
or
Use Decission Task
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
What do you mean by blocking transformation?
Differences between connected and unconnected lookup?
How many numbers of sessions can one group in batches?
How to create a non-reusable instance of reusable transformations?
What is main use of mapplet?
What are the types of data warehouses?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the status code in stored procedure transformation?
What are the guidelines to be followed while using union transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What does role playing dimension mean?
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 have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.