Answer Posted / suraj kedia

Let our source table name is "Name",which is having COL1 and
data in it is BHANU PRASAD (For easier understanding instead
of space between bhanu and prasad,lets take a underscore
i.e. BHANU_PRASAD.

Source ----> Exp t/r ----> target
In the exp t/r take "name" as an input port only and create
2 out put ports as COL1 and COL2.
In COL1 give condition
substr(Name,1,instr(Name,'_',1)-1)

In COL2 give condition
substr(Name,instr(Name,'_',1)+1)


now connect COL1 port form exp to COL1 port in tgt and same
for COL2, than the out put in the target table will be as below:

COL1 COL2
BHANU PRASAD

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2067

---

What is parallel processing in informatica?

1698

---

How do you change a non-reusable transformation to reusable transformation?

989

---

How will the document be delivered to me?

1066

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1759

---

Different sorts of metadata that stores in the storage facility?

1008

---

What can we do to improve the performance of informatica aggregator transformation?

1089

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2552

---

What are the informatica performance improvement tips

1082

---

Explain pmcmd command usage in informatica

1121

---

Differentiate between source qualifier and filter transformation?

1572

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1271

---

What is a sequence generator transformation?

1010

---

Define update strategy?

1210

---

Separate from an archive server and a powerhouse?

953

---