Answer / venky

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


output1 means firstname
output2 means last name

what is the difference between onsite & client site?

1 Answers  

---

When you move from devel to prod how will you retain a variable

1 Answers  

---

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

---

What is the need of building a data warehouse?

2 Answers  

---

how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,

---

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

---

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

---

What are the features of complex mapping?

0 Answers  

---

What is the difference between Normal load and Bulk load?

5 Answers  

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---