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
- 6492 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
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is quality stage?
Which warehouse using in your datawarehouse
How can one find bugs in job sequence?
Is the value of staging variable stored temporarily or permanently?
What is the difference between server job and parallel jobs?
I have a few records just I want to store data in to targets cycling way how?
How to perform incremental load in datastage?
What is datastage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Difference between data warehousing and olap?
What are routines in datastage?
Explain datastage architecture?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is the command line function to import and export the ds jobs?
