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

How can you complete unrcoverable sessions?

1 Answers  

---

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

what is DSS?

3 Answers  

---

How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers   Syntel,

---

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

tell me about your project functionality

0 Answers  

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

0 Answers  

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

What is an Integration service in Informatica?

0 Answers  

---