Interested to Buy Any Domain ? << Click Here >> for more details...
If you done any modifications for a table in back end does
it reflect in informatca warehouse or maping?
- 2 Answers
- 6507 Views
- I also Faced
- E-Mail Answers
Answer Posted / janardhan avula
No..it could not reflect in informatica.informatica is one
of the Dynamic ETL tool using this tool we can design the
the data effectively according to business
requirement..database is different..
I though am i correct.
if u want more info mail me at avula.janardhan@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is pmcmd command?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Can we create a Integration service without a Repository service and vice versa?
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 xml source qualifier transformation in informatica?
What is the use of transformation?
What does reusable transformation mean?
What is data transformation manager process?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Reusable transformation and shortcut differences
How to call shell scripts from informatica?
What are different types of transformations available in informatica?
What is standalone command task?
What is meant by pre and post session shell command?
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
