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
- 5657 Views
- I also Faced
- E-Mail Answers
Answer Posted / supriya
Use Sort stage to get unique recs,write a constraint in the
transformer to remove leading zeros by usig Trim
function.In XFM it sims we can change the datatypes of
required fields.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is difference between symmetric multiprocessing and massive parallel processing?
What are the primary usages of datastage tool?
which r the connectors used in san?
What is the purpose of pivot stage?
Which algorithm you used for your hashfile?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How do u convert the columns to rows in datastage?
What is the difference between validated and compiled in the datastage?
What are the differences between datastage and informatica?
What is oci?
What are stage variables, derivations and constants?
How to RD using transformer?
How to convert RGB Value to Hexadecimal values in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
