I have a scenario which load the data frm single source to
2 targets as T1, T2, and T1 have a P.K and T2 have F.K
relations. first data has to load in T2, and then data load
to T1 if that record exist in T1... how can we acheive it?
Answers were Sorted based on User's Feedback
Answer / babu
Hi raviKumar,
I think u r question has small mistake that is first data
has to load in T1 then only load T2.
By using "Constraint Based load ordering" option u can
achieve this.This option is available in 'Config object'
tab in Session Tabs
(General,Properties,Config
objects,Mapping,Components,Metadata Extensions)
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / siva
We have to take the 2 source instances of the same source
say S1 and S2.
Do the mapping from S1 to T1 and then S2 to T2 by making
lookup on T1. i.e. in same mapping 2 different pipelines.
Go to Mapping Tab --> Target Load Plan
It will show the list of two Source Qulifiers.
Then set the Target Load Plan sequence as first SQ1 and then
SQ2. This will first load T1 and then load T2 by making
lookup on T1.
Is This Answer Correct ? | 6 Yes | 1 No |
what is shortcut in informatica? difference between shortcut,reusable object?
version controlling in informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
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
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
If I have a index defined on target table and if set it to bulk load will it work ?
What are the steps involved in the migration from older version to newer version of Informatica Server?
what is junk dimension
Explain scd type 3 through mapping.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How can you generate reports in informatica?
what is difference between mapping and mapplet ?