Answer Posted / usha

without using update transformation we can update by using
update overide if the target doent have a PK...

:TU

------------------------
push down operation in informatica means it will convert
transfromation logic to SQL query..
3 types..

source push down
target push down
full push down.

------------------------
connected lkp will give good prformence..


lookup gives more tuning performance

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2012

---

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

2258

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4085

---

How to join three sources using joiner? Explain though mapping flow.

1109

---

What are some examples of informatica etl programs?

901

---

update strategy transformation in informatica

1025

---

difference between repository database and repository service?

1096

---

What are the informatica performance improvement tips

1036

---

Plz can any one say me how to get the informatica certification materials and dumps

2014

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2089

---

What is a node in Informatica?

1008

---

What do you mean by enterprise data warehousing?

1013

---

What does cheating measurement mean?

1005

---

What all are steps in up gradation of Informatica server?

1006

---

What is the benefit of partitioning a session?

1117

---