Hi Every One When i Start the Workflow, Table is Going to be
Stored in the target database But the columns are not going
to the target database table in my PC , please give me the
solution and waiting for solution
Answers were Sorted based on User's Feedback
Answer / swaroop(atiric)
once check out with ur transformations , the output ports
should generate the proper data as per the given conditions
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / komala
once check out your output ports and input ports and the
pipeline between
| Is This Answer Correct ? | 1 Yes | 0 No |
How will you combine 3 different sources with a single source?
what type of transformation is not supported by mapplets?
Why we require dwh in particular projects?
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
What is IQD file?
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 all, In SOA architecture i.e 8.6 , What is mean by node exactly?
What is meant by pre and post session shell command?
what is the architecture of any Data warehousing project?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
What are the new features of informatica 7.1?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?