Answer / venkatesh

1) Open the Sequential file stage properties.
2) Go to Format > Type Default > Date > Format String.
3) Type the format of the string in which the source date is
coming. For ex. For 20101201 - Type %yyyy%mm%dd.
4) Go to Column tab, Chose SQl Type as Date.
Now, try to view data. YOu should be able to see date as
2010-12-01.

Answer / p.n.chowdary

I think this is not posible......
But we can load date in sequenatial file stage.

Answer / sneha

Hi ,

In seq stage , in format tab , there is option where we can define format for date . Then we can read date data with date datatype .

correct me , if I am wrong

Answer / saidarao

by using transformer stage
in functions one option like-string 2 date ,we can possible.

Answer / ramesh

Datastage contains so many inbuilt functions...
simply we use this type conversion like this
StringToDate(file1.Date1,"%mm/%dd/%yyyy");

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

wt is the difference between swith and filter stage

6 Answers   IBM,

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

What is container and then types?

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  

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

What are the different database update actions available?

1 Answers   HP,

How do you import and export data into datastage?

0 Answers  

How to clean the datastage repository?

0 Answers