Answer / kumar

use reg_extract

refer this link
https://etltechsolutions.wordpress.com/2016/06/01/using-reg_extract/

its has the logic u need to change a bit as you have char as month.

Answer / isha

to_char(to_date(Date, 'dd/mon/yyyy'), 'dd mon yyyy')

What is flashback table ? Advance thanks

0 Answers   Puma,

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

What are the different options available for update strategy?

0 Answers  

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  

---

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

---

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  

---