Answer / aa

Use reg_replace

reference
https://etltechsolutions.wordpress.com/

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

can every transfomation reusable?how?

2 Answers   Wipro,

---

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  

---

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

---

What do you mean incremental aggregation?

0 Answers  

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

---

WAT IS TEXT LOAD?

3 Answers   Wipro,

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---