Answer / sateesh amanchi

Hi,

version control is an option while installing the
informatica s/w.

eigther enable or disable the version control option it
will create an instance to an object.

FOR EXAMPLE (version control enable): if you create a
mapping in informatica, so it will create an instance for
that mapping.if you update that mapping, again an instance
is create for updated mapping.

FOR EXAMPLE(version control disable): if you create a
mapping in informatica, so it will create an instance for
that mapping.if you update that mapping again an instance
is create for updated mapping and deleted first(intial)
instance.

Answer / ramanaidu kolli

One project developed in old version (informatica 6.1)in
earlier now we need to add a new fields in target database
columns but now we are using (informatica 8.6 version) so
client requirement need to transfer data Earlier version to
New Version in this scenario we are using Version control
option

how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

---

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

0 Answers  

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  

---

What is the target load order?

3 Answers   HCL, Informatica,

---

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

---

how to we create datamart?

2 Answers   HSBC,

---

What are connected or unconnected transformations?

0 Answers   Informatica,

---