Answer Posted / 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

update strategy transformation in informatica

1068

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1273

---

What is meant by pre and post session shell command?

1161

---

How can we delete duplicate rows from flat files?

1225

---

What is parallel processing in informatica?

1718

---

Explain direct and indirect flat file loading (source file type) - informatica

1320

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1177

---

Informatica settings are available in which file?

992

---

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

1018

---

How to generate sequence numbers?

1091

---

Please let me know how to make Data masking in informatica..

1729

---

What are the advantages of informatica?

1014

---

What the difference is between a database, a data warehouse and a data mart?

1155

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8124

---

what is song in infrmatica...?

2237

---