Interested to Buy Any Domain ? << Click Here >> for more details...
why we use source qualifier transformation?
- 16 Answers
- 46479 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / ravi kumar
This type of an active transmission. which allows to read the data from relational or flat file.
Ex: our source Or flat file is relational that session reads the data through source qualifier. so when ever our source is relational or flat file we must and should use this. with out source qualifier session cann't read the data. when it run time
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What you know about transaction control transformation?
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
Can anyone tell me the new features in Informatica 9 Version?
What is a code page?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How to generate or load values in to the target table based on a column value using informatica etl tool.
In which transformation you cannot drag ports into it?
On which transformations you created partitions in your project?
What is a repository manager?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How can we use batches?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
what is the difference between informatica6.1 and infomatica7.1
Explain the difference between mapping parameter and mapping variable?
how many types of dimensions are available in informatica?
