Interested to Buy Any Domain ? << Click Here >> for more details...
what are the transformations that are used in data
cleansing ? and how data cleansing takes place ?
- 3 Answers
- 11766 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / avinash
Expression tranformation is used in data cleansing.
If ur target table consist of not null column and source
table consisting null columns so assign some value in
expression tr.
and then pass data to target.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shashiall
Source Qualifier Transformation and Expression
Transformation are used for Data cleansing.
Data types ,Date formats,null ..not null
constraints ..these r main things considered in the data
cleansing.
| Is This Answer Correct ? | 1 Yes | 0 No |
Hi Friends,
My point of view FILTER AND EXPRESSION TRANSFORMATIONS are
used to data cleansing.
| Is This Answer Correct ? | 0 Yes | 0 No |
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 update strategy transformation ?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the difference between STOP and ABORT options in Workflow Monitor?
How can we use mapping variables in informatica? Where do we use them?
comonly how meny mappings r there in Banking projects?
What happens if the info. Server doesn't find the session parameter in the parameter file?
star and snowflake schema?
What is decode in static cache?
How to extract the informatica rejected data?
scd methodology?
Teradata 
