Answer Posted / venky

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


output1 means firstname
output2 means last name

In informatica workflow manager, how many repositories can be created?

1271

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1004

---

In how many ways we can create ports?

1067

---

Explain in detail about scd type 1 through mapping.

1300

---

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?

1718

---

Explain the types of transformations?

1007

---

Describe expression transformation?

1044

---

COM components can be used in Informatica

2315

---

tell me about your project functionality

2295

---

What is a sorter transformation?

1041

---

what is the hint? how to use it to reduce the query processing in program?

7634

---

What is parallel processing in informatica?

1621

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1002

---

What is union transformation in informatica?

1101

---

What is an aggregator transformation?

1032

---