Interested to Buy Any Domain ? << Click Here >> for more details...
i having mapping
emp---> sq_emp--->target
using this mapping i have to load dept table values into
target... (condition assume there is no primary and foreign
key relation between emp(table x) and dept (table Y))
- 5 Answers
- 9845 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / snjsngh15
Based on the constraint based load we can load the data IT means emp table in target t1 and dept in target t2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
During the running session, output files are created by informatica server. Enlist few of them.
What is native users?
What are pre and post-session shell commands?
Differentiate between a repository server and a powerhouse?
4 yrs etl devloper roles and responsibilities?any body give solutions
How can one identify whether mapping is correct or not without connecting session?
What is dimensional table? Explain the different dimensions.
How can you validate all mappings in the repository simultaneously?
Can informatica load heterogeneous targets from heterogeneous sources?
Enterprise data warehouse your projects phase by phase explain?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
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
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is aggregate cache in aggregator transformation?
What are the advantages of using informatica as an etl tool over teradata?
