Answer Posted / raghava

Use following steps to compleate the task.

Step:I

Use an expression transformation.In the experssion
transformation crate output ports for each inputport.

In current examle:
out_F.NAME=IIF(NOT ISNULL(F.NAME),F.NAME.'UNNOWN')
out_M.NAME=IIF(NOT ISNULL(M.NAME),M.NAME.'UNNOWN')
OUT_L.NAME=IIF(NOT ISNULL(L.NAME),L.NAME.'UNNOWN')

Step:II

Create Sequence Generator transformation .Connect NEXTVAL
port of Sequence Generator transformation to S.NO in targt

Step:III

Connect out_F.NAME-->F.NAME in target
out_M.NAME-->M.NAME in target
out_L.NAME-->M.NAME in target

How can you differentiate between powercenter and power map?

1140

---

What are the databases that informatica can connect to windows?

1096

---

What is the sql query overwrite in source qualifier in informatica

1142

---

Reusable transformation and shortcut differences

1880

---

where to store informatica rejected data?

1139

---

What is transformation?

1159

---

Describe the impact of several join conditions and join order in a joiner transformation?

1115

---

what is Active lock explain

2857

---

What do you mean by worklet?

1115

---

what are 3 tech challenges/ common issues you face?

2395

---

What is dynamic cache?

1085

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2055

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1382

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1955

---

Why do we need informatica?

1054

---