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

Where is metadata stored?

1129

---

What is a shortcut and copy in Informatica and how two are different with each other?

1208

---

State the limitations where we cannot use joiner in the mapping pipeline?

1078

---

Target increases every day even though no new record was inserted

1592

---

Performance tuning( what you did in performance tuning)

1999

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2733

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2183

---

How do you take back up of repository?

1165

---

Explain the features of connected and unconnected lookup.

943

---

What is meant by LDAP users?

1219

---

Parameter and variable differences

2070

---

Clarify the aggregator change?

1036

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7415

---

What is an unconnected transformation?

1098

---

can u give example for factless fact table

6670

---