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

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

What is meant by lookup transformation?

0 Answers  

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

EXL informatica Questions

0 Answers  

---

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

How can we remove the duplicates from flat file source?

0 Answers  

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

What is update override?

1 Answers   Accenture,

---

How might you approve all mappings in the archive all the while?

0 Answers  

---