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

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

---

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

0 Answers  

---

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,

---

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

---

What are the different clients of powercenter?

0 Answers  

---

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

---

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

9 Answers   TCS,

---

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

What is informatica etl tool?

0 Answers  

---