Answer / swetha

Maping: It is a set of source and target definitions linked
by transformation objects that define the rules for
transformation.

Session : It is a set of instructions that describe how and
when to move data from source to targets.

Answer / suresh

MAPPING: it is a graphical representation of data flow from
source to target which included some business
transformation logic

SESSION: It is a set of instructions that describe how and
when to move data from source to targets.

Answer / surya

Mapping:When a Source definition transformation and Target
definition transformation are connected in a sequence
through a ETL follow of data.Such a sequence is called
Mapping.

Session:It is a task,used to migrate the data from source
to target using some instructions by informatica server is
called Session.

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,

---

how we do performence tuning in informatica

3 Answers  

---

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  

---

difference between stop and abort

2 Answers  

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---

how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy

2 Answers  

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers   HCL,

---