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

How can you differentiate between powercenter and power map?

1093

---

What is enterprise data warehousing?

1050

---

Differentiate between sessions and batches?

1022

---

whats the logic to load the lower level of granularity of data to fact table.

2276

---

What is the status code in stored procedure transformation?

1183

---

Do you find any difficulty while working with flat files as source and target?

1099

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10175

---

Briefly describe lookup transformation?

1046

---

What all are steps in up gradation of Informatica server?

1047

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2362

---

What does “tail –f” command do and what is its use as an Informatica admin.

1109

---

Enlist some properties of sessions.

1082

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1080

---

what is the difference between informatica6.1 and infomatica7.1

2280

---

What are the designer tools for creating transformations?

1119

---