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
- 6415 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
what is the difference between 7.1,7.5.2,8.1 versions in datastage?
what about data stage requirement
What is use Array size in datastage
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
How the ipc stage work?
How to convert alpha Numeric values to alpha using functions?
How to display errors in datastage?
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
How to Remove Duplicate using SQL?
Which type of joins Merge stage can support?
Why fact table is in normal form?
Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.
Teradata 
