Answer / venky

output1=substr(name,1,instr(name,' ')-1)
output2=substr(name,instr(name,' ')+1)


output1 means firstname
output2 means last name

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---

Define Update Override?

1 Answers  

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

why we use stored procedure transformation?

4 Answers   IBM,

---

i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater

5 Answers  

---

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

2 Answers   TCS,

---

Why we require dwh in particular projects?

1 Answers   Amdocs,

---

Can you copy the batches?

3 Answers  

---

Kimball and Inmon methodologies?

2 Answers  

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

---

how can we calculate fact table size?

1 Answers  

---