What is CDC? How to implement CDC?
- 4 Answers
- 22224 Views
- People Tech, TCS, I also Faced
- E-Mail Answers
Answer Posted / abhinaw prakash
CDC is changed data capture.
We can implement the same in Informatica using a filter transformation and passing only the Incremental rows.
A better option in this would be to dynamically create a parameter file every time the workflow runs and using the its value in the filter expression.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
How to partition the Session?
Enlist the differences between database and data warehouse.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a sequence generator transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
State the limitations where we cannot use joiner in the mapping pipeline?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
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
How to generate sequence numbers without using the sequence generator transformation?
Explain how many types of dimensions are available in informatica?
wat are deployement groups in informatica, how it will be used for developers
What is data caches/ index caches?
What do you understand by term role-playing dimension?
What are different types of transformations available in informatica?
