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

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

---

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

---

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

Sequence generator, when you move from develoment to production how will you reset

0 Answers  

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

How to load data in informatica ?

0 Answers  

---