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
- 6458 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
root tree will find which is server job and which is parallel job?
Why do we use link partitioner and link collector in datastage?
in oracle target stage when we use load option and when we use upsert option?
What are the processing stages?
What are the important features of datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How to reverse the string using SQL?
What is the difference between operational data stage (ods) and data warehouse?
Explain usage analysis in datastage?
What is the roundrobin collector?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the features of datastage flow designer?
How and where you used hash file?
What are the different type of jobs in datastage?
