Interested to Buy Any Domain ? << Click Here >> for more details...
 Code page compatibly –Where all changes are made to
handle the scenario.
- 1 Answers
- 6045 Views
- DELL, I also Faced
- E-Mail Answers
Answer / mike
when two code pages are compatible then the characters
encoded in the code pages are virtually identical. If the
code pages are identical, then there will not be any data
loss. One code page can be a subset or superset of another.
For accurate data movement, the target code page must be a
superset of the source code page.
Superset - A code page is a superset of another code page
when it contains the character encoded in the other code
page, it also contains additional characters not contained
in the other code page.
Subset - A code page is a subset of another code page when
all characters in the code page are encoded in the other
code page.
| Is This Answer Correct ? | 1 Yes | 0 No |
how will you get 21 to 30 record from 50 records?
 Code page compatibly –Where all changes are made to handle the scenario.
What is the difference between source qualifier transformations source filter to filter transformation?
Make a note of the quantity vaults made in informatica?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
What is Target Update Override? What is the Use ?
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
Flat file heaving 1 lack records and I want to push 52000 records to the target?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
How will you update the first four rows and insert next four rows in a mapping?
COM components can be used in Informatica
Teradata 
