DSXchange

DateEffective column coming from source is having data type as Date for that i need to do minute minus one and update the target table ,


waiting for reply ASAP


Thanks in advance

iam facing this warning, from lookup stage , data types and every thing are corect for the mapping columns (CACTIVE is column name)

Lookup_3: When checking operator: The view adapter has a binding for the non-existent destination field "CACTIVE".

For one column dattype is varchar and data is like 2008-10-20k , after transformer 5 records are rejecting, but from source(seq stage) all records are coming , m getting warning APT_CombinedOperatorController(1),0: Data string ' ' does not match format '%yyyy-%mm-%dd': an integer was expected to mat...

some .csv file are there in Filenamelist.txt File that one by one should be read and has to be moved to FileNamesListProcessed.txt requirement is : 1. Open file (FileNameList.txt) 2. Read first line put in Ans 3. Delete that first line in FileNameList.txt 4. Open File (FileNameListProcessed.txt) 5. ...

i want to use the below script as routine(c++ code only its client req) #!/usr/bin/perl ####Declarations $in_file = "/correct_path/DirNameList.txt"; #name of the file where directory structures are stored $log_file = "/correct_path/FileNameList.txt"; $targetdir = "/abc/dev/p...

I need routine for below process (i need only routine not shell script) I have a DirNameList.txt file it contains the path names. From above paths I have to check .csv files and prepare a list named FileNameList.txt, move those files to target path named /abc/dev/pqr. Here we have to read the FileNa...

I need routine for below process I have a DirNameList.txt file it contains the path names. From above paths I have to check .csv files and prepare a list named FileNameList.txt, move those files to target path named /abc/dev/pqr. Here we have to read the FileNameList.txt one by one and move it into ...

i have used table for refference , there are no duplicates in this but m getting warning like this ,
Ignoring duplicate entry at table record 22; no further warnings will be issued for this table
how to avoid this

Regards
Ravi

Maxperiodid_Agg: When checking operator: When binding output interface field "MAX_PERIOD_ID" to field "MAX_PERIOD_ID": Implicit conversion from source type "dfloat" to result type "int32": Possible range/precision limitation. (based on period_id(integer) m cal...

how can we use the default routines(examples) in transformer stage , explain clearly plz

cs}}}: When checking operator: Operator of type "APT_TSortOperator": will partition despite the
preserve-partitioning flag on the data set on input port 0.

when iam executing (dsjob -ljobs projectname) its not working m getting warning like dsjob not found , i have tried this in opt/IBM/datastage , how to run and where to run dsjob command

how to avoid this warning: Ignoring duplicate entry at table record 21; no further warnings will be issued for this table

to run job in unix command prompt