if the source file is
CID,CCODE,CONNDATE,CREATEDBY
0000000224,1000,20060601,CURA
0000000224,2000,20050517,AFGA
0000000224,3000,20080601,TUNE
0000000225,1000,20020601,CURA
0000000225,2000,20050617,AFGA
0000000225,3000,20080601,TONE
AND TARGET is oracle
following are the validations
cid loaded with unique records
leading zeors has to be deleted while loading cid in target
load only customer who got early connected to company
conn_date should be loaded into oracle date format
cid datatype is varchar2 in target
conn_date is data datatype
ccode is varchar2
0000000224,1000,20060601,CURA
0000000224,1000,20060601,CURA
Answer Posted / rajesh
1)first sort d data in accending order based on date and remove duplicates
2)in transformer write a derivation to delete leading zeros by using function trim. eg- trim(col 1)
3)change date format by using date functions in transformer
4)change d data types to be fitted according to following ask
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the different options associated with dsjob command?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
what is the use of materialized view?
How to manage date conversion in Datastage?
What is apt_config in datastage?
Differentiate between datastage and datastage tx?
What is aggtorec restructure operator?
What is a ds designer?
What is the difference between datastage and datastage tx?
Lookup constraints
What are some prerequisites for datastage?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How many types of stage?
Have you have ever worked in unix environment and why it is useful in datastage?