Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 6491 Views
- I also Faced
- E-Mail Answers
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
How to find value from a column in a dataset?
root tree will find which is server job and which is parallel job?
Explain the importance of surrogate key in data warehousing?
what is use of SDR function?
how can we create rank using datastage?what is the meaning of rank?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Difference between server jobs & parallel jobs?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is data partitioning?
What are the enhancements made in datastage 7.5 compare with 7.0?
Explain ibm infosphere information server and highlight its main features?
what is repositery?
