Answer / babu

Hi All,


By using Normalizer Transformation we will achive this.

Mapping:
========

Src==>SQ==>Nrm(Normalizer)==>Srt(sorter)==>Trg

Nrm:Column(Occerence 3)

Column1 (inputport)
Column2 (inpuport)
Column3 (inputport)

Column (outputport)===> Srt ==>Trg

Answer / swapnil

no need to use normalizer here, take 3 expression and 3
instance of target.
Create 3 expression transformations exp_1,exp_2 and exp_3
with 1 port each. Connect col1 from Source Qualifier to
port in exp_1.Connect col2 from Source Qualifier to port in
exp_2.Connect col3 from source qualifier to port in exp_3.
Make 3 instances of the target. Connect port from exp_1 to
target_1. Connect port from exp_2 to target_2 and connect
port from exp_3 to target_3.

Answer / kuldeep singh rathore

Create 3 expression transformations exp_1,exp_2 and exp_3
with 1 port each. Connect col1 from Source Qualifier to
port in exp_1.Connect col2 from Source Qualifier to port in
exp_2.Connect col3 from source qualifier to port in exp_3.
and we merge all output of all 3 expressions by UNION trans
and direct load to tgt from union

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

---

In warehouses how many schemas are there?

0 Answers  

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

What is decode in informatica?

0 Answers  

---

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

how can we use sorter transformation in joins?

5 Answers   IBM,

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

difference between stop and abort

2 Answers  

---