DSXchange

Modify_1: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "hiredate" to field "hiredate": No default conversion from source type "timestamp" to result type "date"

We have a scenario like this given below

NAME LOCATION

balu Hyd
balu chennai
balu banglore


we want output like this in target table

NAME LOCATION

balu hyd/chennai/bangalore



_________________[/i]

We have a scenario like this given below

name Location
balu Hyd
balu chennai
balu banglore

we want ouput like this in target

balu --------> hyd/chennai/bangalore

The qst is how would u do that

how much volume of data can load in Xml stage in datastage per file?

how to run script from datastage?

how to handle CLOB datatype in Datastage?

what is Functional dcoument & Technical dcoument.
pls expain in detail

what is bulk load in datstage..?
explain how many loads are there?

i have one seq file and three sequential files in taget.OK my question is in source there is records like 1,,2,3,4,5,6,7,8.. in target i want 1 and 4rec goes to first seq file 2 and 5 rec goes to second seq file 3 and 6 rec goes to third seq file i hope tht u got it.how to do that?

what is OCI in datastage px..?

pls expalin in detail what is use of that..?

is it available ....in parallel or server jobs?

the string is like in the source data
" abcde 1234 efgh 45678 nmhj 7895 ". i
In parallel jobs I want to convert in target like "abcde efgh " ie i want to remove numeric values and send string to target