Answer / bharath

Hi,
First convert your column datatype date to string using modify
stage and then by transformer stage change it as
StringToDate(datestring,["yy-dd-mm"])
then u get...

Answer / ram

hi,

before importing the metadata into the sequential file
convert the column datatype date to string, then use
transformer stage change it as stringtodate.

What all are the different way to run a job?

0 Answers  

---

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

---

what is advantages of snowflake when it is used?

3 Answers   IBM,

---

How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers   Cap Gemini, TCS,

---

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 Answers  

---

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

---

How rejected rows are managed in datastage?

0 Answers  

---

What are the third party tools you used in your project?

1 Answers   IBM,

---

How you can fix the truncated data error in datastage?

0 Answers  

---

sed,awk,head

0 Answers   CTS,

---

I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on

1 Answers   Accenture,

---