Answer / pradeep

Use SQL Override and apply the TO_DATE function against the
date columns with the appropriate format mask.

Answer / anupam baruah

You can write a procedure and call it to change the date
format as per your requirement

Answer / isha_gtb

IIF(IS_DATE(col1,'dd/mm/yyyy'),to_date(col1,'dd-mm-yyyy),NULL)


Is_date to check the format
and to_date to change it to desired format

where is the reject loader .

1 Answers  

---

What is the difference between OLTP and ODS?

4 Answers  

---

how did u understand business requirement?

2 Answers   TCS,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

Separate from a database, an information bazaar, and an information stockroom?

0 Answers  

---

---

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

---

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

---

what is diffrence b/w joner and union transfermation

6 Answers  

---

What is dynamic cache?

0 Answers  

---

A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,

---

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---