Answer / balaramesh

first create one normalizer transformation ,double click on
it ,select normalizer tab create column(column name is
cityandstate).set 2 in occurs field and datatype is
string ,next click ok. then automaticaly two input ports
(cityandstate,cityandstate)and threee out pouts
(cityandstate,gk_cityandstate,gcid_cityandstate) are
created.then set city is one inputport(cityandstate) and
state is another input port(cityandstate).set citystate
(outputport) to target table.

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,

---

define galaxy repository in informatica

0 Answers  

---

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,

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

---

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

---

how do u tune queries?

1 Answers  

---

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,

---

why we use materialized view over view?

1 Answers   Zensar,

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

how to move the mappings from your local machine to claint place?

2 Answers  

---