Interested to Buy Any Domain ? << Click Here >> for more details...
Which transformation should we use to normalize the COBOL
and relational sources?
- 4 Answers
- 13565 Views
- DELL, IBM, Lehman Brothers, I also Faced
- E-Mail Answers
Answer Posted / usha
by using normalizer transformation we can normalize the
COBOL and relational sources.when ever we drag COBOL
soureces in mapping designer by default normalizer
transformation appears
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Difference between Target-based loading and constraint-based loading?
How to start a workflow using pmcmd command?
What is session task and command task?
differences between service based and product based?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
In informatica workflow manager, how many repositories can be created?
What is option by which we can run all the sessions in a batch simultaneously?
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 are the data movement modes in informatica?
To import the flat file definition into the designer where should the flat file be placed?
Describe the impact of several join conditions and join order in a joiner transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How can you generate reports in informatica?
Sequence generator, when you move from develoment to production how will you reset
Why update strategy and union transformations are active? Explain with examples.
