DSXchange

i actually got the maximum of date having YYYYMMDD format. but when i had YYYY-MM-DD it was not able to pick up the maximum. so i used a routine to strip of the extra characters in between and then used the aggregator.
anyway thanks for your attention and help.

thanks for the immediate response.
my input is not directly connected to the aggregator. so i think i need to use the iconv function. but the ouptut which i get should come only after
the oconv. right!

hi all, i need to extract the latest date from a column which has datatype as date. this column is extracted from teradata which is in YYYYMMDD. but when i use an aggregator MAX function, then i get an error saying that unable to convert string so taken Null. into which format should the date be con...

can i grab data from a "view" which is in teradata (using an API).

thanks James,

i have got the olution.i have used the geomatch multiple strategy.
thank u

hi, thanks for ur reply. actually i have 2 files. the matching fields in the file is the Date_of_birth and SSN(number). the file A (say the transaction file) has say for example 10 records belonging to a person. But what i thought, e sacond file say File B which i said was unique is nt so. like for ...

i have a master sequence which calls sequence jobs. if one my sequence fails it is unconditional for the remaining to run. but when one of my sequence aborts for the first time the master sequence continues with the remaining as expected. when it starts running for the second time the sequences befo...

i have a master sequence which calls sequence jobs. if one my sequence fails it is unconditional for the remaining to run. but when one of my sequence aborts for the first time the master sequence continues with the remaining as expected. when it starts running for the second time the sequences befo...

it is always better to break the jobs into smaller and call them in a sequence as you can have savepoints in a sequence and hence you don't have to restart it from the beginning when it aborts

hi, i have the following scenario. i have an incoming source file which has multiple records which r not duplicates but consist of transaction data for the same person. And i have the existing file which has records of unique persons. i need to match both the files. which MATCH strategy do i need to...

hi,
could any one explain me how do i import the sequential file definitions from a datastage job into the quality stage.

thanks.
kiran

thanks Ray!
but i think we have to take care of the enf of month and the leap years too. right!

hi i am getting data having timestamps from the sources in the west coast.
i want to change the entire timesatamp column adding an hour to the timestamp and converting it into the central. can anyone help me doing this.
Thanks in advance.

i solved the problem using a shell script.
thank you though for trying to help me

you can check whether you have proper permissions to rwx to it.