hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---

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,

---

HOW TO YOU LOAD TIME DIMENSION

1 Answers  

---

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

---

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

---

What are the Differences between static cache and dynamic cache?

1 Answers  

---

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

---

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

---

Why is meant by direct and indirect loading options in sessions?

4 Answers  

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

---

What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,

---