Answer / aa

Use reg_replace

reference
https://etltechsolutions.wordpress.com/

What is informatica? Why do we need it?

0 Answers  

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  

---

Why touse stored procedure in ETL Application?

2 Answers  

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

When will you use SQL override in a lookup transformation?

1 Answers  

---

How to extract the informatica rejected data?

0 Answers  

---

can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

---

how can u load the data in time dimension?

3 Answers  

---