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.

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---

What is power center repository?

1 Answers  

---

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

3 Answers   Alcatel-Lucent, ECI Telecom,

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

---

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

---

What is factless fact schema?

1 Answers  

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

what is plsql table?

2 Answers  

---

What is repository manager?

0 Answers  

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---