Answer / vivek nigam

If the datatype of the input is date then you need to
convert it to Char and the you can formulate it to Date
with the new format.

to_date(to_char(<Input Field>,'dd-m-yyyy'))

Answer / jerry

to_date(to_char(Field_Name,'dd-mm-yyyy'),'dd/mm/yyyy');

Answer / nish

Can also use ICONV

Answer / ashok

using field we can cut yyyy,mm,dd as separate and using
concat we can combine as dd mm yyyy

i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?

1 Answers   ABC,

---

How to remove blank spaces from data?

3 Answers  

---

What is quality stage?

0 Answers  

---

what is datastage job Monitoring

6 Answers   CTS,

---

what is normalization and denormalization

2 Answers   CTS,

---

HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

1 Answers   Infosys,

---

how many dimentions and fact tables used in your project and what are names of it?

3 Answers   Tech Mahindra,

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers  

---

What is audit table?

1 Answers  

---

how to closeing records after 10,000 records come?

3 Answers  

---

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

---

How one source columns or rows to be loaded in to two different tables?

0 Answers  

---