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.

how can we use sorter transformation in joins?

5 Answers   IBM,

---

What are the various types of transformation?

0 Answers  

---

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

---

What is the function of look up transformation?

0 Answers  

---

Explain sessions?

0 Answers  

---

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

How to open an older version of an object in the workspace?

0 Answers  

---

Do you find any difficulty while working with flat files as source and target?

0 Answers  

---

can a port in expression transf be given the name DISTINCT

3 Answers  

---

How informatica recognizes mapping?

2 Answers   CTS,

---

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

---