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 will you get 21 to 30 record from 50 records?

6 Answers  

---

what is degenerated dimension

6 Answers   Cap Gemini,

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

---

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

---

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

---

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  

---

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 Answers  

---

explain abt union t/r?

1 Answers   IBM,

---

what is the difference between mapplet & stored procedure?

1 Answers  

---