Answer / kiran

source-sq-exp-tgt
in exp take two new ports
o1- substr(string,2,1)
o2-concat('20',(substr(string,3)))

let me know if i m wrong

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,

---

how can i invoke pmcmd in command line prompt

1 Answers  

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

expain about the tune parameters?

0 Answers   TCS,

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

---

what is dimension table?

17 Answers  

---

How do you load alternate records into different tables through mapping flow?

0 Answers  

---

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

---

How/where can i install Informatica software with oracle or teradata as database

0 Answers  

---

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

---

From where we can start or use pmcmd?

3 Answers  

---

What is a joiner transformation and why it is an active one?

0 Answers  

---