Can you use one mapping to populate two tables in different
schemas

Answers were Sorted based on User's Feedback



Can you use one mapping to populate two tables in different schemas..

Answer / pal

Yes we can use one mapping to populate data in multiple
schemas.

Is This Answer Correct ?    3 Yes 0 No

Can you use one mapping to populate two tables in different schemas..

Answer / sanjay

Use $DBConnection instead of connection in session for
source and change the schema name through the parameter file

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,


What is meant by LDAP users?

0 Answers  


How we can create indexes after completing the loan process?

0 Answers  


What is the difference between OLTP and ODS?

4 Answers  


my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,






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

0 Answers  


Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  


How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  


Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  


Explain constraint based loading in informatica

0 Answers   Informatica,


how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table

2 Answers  


Categories