Define maping and sessions?
Answers were Sorted based on User's Feedback
Answer / swetha
Maping: It is a set of source and target definitions linked
by transformation objects that define the rules for
transformation.
Session : It is a set of instructions that describe how and
when to move data from source to targets.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / suresh
MAPPING: it is a graphical representation of data flow from
source to target which included some business
transformation logic
SESSION: It is a set of instructions that describe how and
when to move data from source to targets.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / surya
Mapping:When a Source definition transformation and Target
definition transformation are connected in a sequence
through a ETL follow of data.Such a sequence is called
Mapping.
Session:It is a task,used to migrate the data from source
to target using some instructions by informatica server is
called Session.
Is This Answer Correct ? | 0 Yes | 2 No |
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
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
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
How to generate the HTML output using Informatica.
What is main use of mapplet?
What are the transformations that are not supported in mapplet?
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
in oracle write query yourname+1 from dual
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
List the transformation in informatica.