How informatica process data means how informatica works?

2 Answers   TCS,

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

---

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers   IBM,

---

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---

What is decode in static cache?

0 Answers  

---

What is joiner change?

0 Answers  

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,

---