Answer Posted / jagan

Value of mapping parameter remain constant for a session run. Server reads its value on every run from parameter file. its value can not be changed at the time of session execution. When ever next time session runs, it reads the parameter value again from parameter file.

What is event and what are the tasks related to it?

1053

---

How to improve the performance of a session using sorter transformation?

1091

---

Why update strategy and union transformations are active?

988

---

What is workflow monitor?

997

---

On which transformations you created partitions in your project?

1249

---

Explain the etl program with few examples.

965

---

what is the -ve test case in your project.

2328

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2075

---

What are the types of caches in lookup?

974

---

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?

1714

---

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

4067

---

How would you copy the content of one repository to another repository?

948

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1016

---

How to do unit testing in informatica?

1121

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2312

---