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 to differentiate between the active and passive transformations?

709

---

How do you update the records with or without using update strategy?

755

---

How can one identify whether mapping is correct or not without connecting session?

1019

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1772

---

What is a standalone command task?

775

---

---

What do you mean by filter transformation?

644

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

725

---

What is an Integration service in Informatica?

801

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1623

---

What is lookup transformation?

703

---

What is workflow? What are the components of workflow manager?

808

---

What is the difference between STOP and ABORT options in Workflow Monitor?

802

---

How do you load alternate records into different tables through mapping flow?

1420

---

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

1910

---

What the difference is between a database, a data warehouse and a data mart?

685

---