How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
- 10 Answers
- 24229 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / aakansha
It is not possible to join a flat file and relational source
without joiner/lookup. Source qualifier is used for
heterogeneous source...means source belongs to same
database...in the ur case flat file and relational source
not belong to same database so...we cant join it into SQ.
| Is This Answer Correct ? | 15 Yes | 11 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
Explain incremental aggregation in informatica
expain about the tune parameters?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How we can create indexes after completing the loan process?
How do you load only null records into target?
What is a stored procedure transformation?
What is enterprise data warehousing?
How many ways are there to create ports?
What are the different components of powercenter?
Differentiate between a database and data warehouse?
What the difference is between a database, a data warehouse and a data mart?
What is the need for an etl tool?
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
What is resilience time?
