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

Describe expression transformation?

1047

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1976

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2146

---

what is the size of u r source(like file or table)?

2203

---

Tell me about MD5 functions in informatica

879

---

Which transformation is needed while using the Cobol sources as source definitions?

1130

---

EXL informatica Questions

1315

---

waht type of interface is used for testing the data in informatica

2196

---

can we override a native sql query within informatica? How do we do it?

1060

---

Make a note of the quantity vaults made in informatica?

945

---

which one is better performance wise joiner or look up

1031

---

Please let me know how to make encryption and decryption with example?

1852

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2243

---

Clarify the utilization of aggregator cache record?

947

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1745

---