Answer / 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

Answer / raj

Nice answer keeep it up

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

---

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,

---

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers  

---

What are the tasks that source qualifier performs?

1 Answers  

---

How can we store previous session logs?

0 Answers  

---

how to work with mapplet designer in informatica?

7 Answers  

---

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

---

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

---

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

---

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

3 Answers   CTS, Wipro,

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---