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

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

---

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

---

what is the gap analysis?

1 Answers  

---

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

---

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

---

---

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  

---

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---

Without using any transformations how u can load the data into target?

15 Answers   IBM,

---

Describe data concatenation?

0 Answers  

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

Write the different tools in the workflow manager?

0 Answers  

---

When will you use SQL override in a lookup transformation?

1 Answers  

---