Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

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

2 Answers   TCS,

---

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

---

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

---

What is a grid in Informatica?

0 Answers  

---