Answer / lokesh

If you want to see result in quarterly based with all other information like location, branch then we can go for normalizer transformation.

Your normalizer transformation looks like this for above example:

Field Level Occurs Description
Location 1 0
Branch 2 2 In each record we can see branch detail occurs two times
result 2 4 For each branch 4 times we can see quarter result, so in a record 4(occurs) X 2 (level) = 8 times

It automatically create input/output port depends on your level and occurs. Also generates some output key ports. You can see more detail on key port in help material.

what are the limitation of sorter transformation?

2 Answers   TCS,

---

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

---

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

---

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

---

How will you convert rows into columns or columns into rows

1 Answers  

---

Mapplets can you use an active transformation in a mapplet,

1 Answers  

---

What is A complex mapping?

3 Answers   TCS,

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

Why do you use Mapping Parameter and mapping variable?

1 Answers  

---

Explain informatica architecture - version 8 / 9

1 Answers   Informatica,

---

explain one complex mapping with logic? sales project?

1 Answers   Accenture, JPMorgan Chase,

---

In joiner, how to load Master table in Target?

2 Answers  

---