Answer Posted / redflower

src->sq->exp->router->trg1
->trg2

create one variable port and write the substr() function
ename like k% is goes to one trg and remaining records goes
to another trg by using router t/r

How to update or delete the rows in a target, which do not have key fields?

1121

---

What is informatica powercenter repository?

1144

---

Explain the different dimensions.

917

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1036

---

What is dynamic cache?

974

---

What are the issues you have faced in your project? How did you overcome those issues?

2292

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1933

---

Explain lookup transformation is active in informatica

1038

---

How do you convert single row from source into three rows into target?

1095

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9739

---

How might one distinguish in the case of mapping is right or not without associating session?

1028

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2183

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4039

---

Does an informatica transformation support only aggregate expressions?

973

---

Can you use flat files in Mapplets.

2612

---