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
- 6590 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
What is difference between server jobs & parallel jobs?
Define Routines and their types?
describe the Steps to confiure a Qlogic switch
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is a merge?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
how to export or import the jobs in .ISX file
What are datastage sequences?
Difference between server jobs & parallel jobs?
Why do you need stage variables?
What are the components of ascential data stage?
Explain the importance of surrogate key in data warehousing?
Define meta stage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Does datastage support slowly changing dimensions ?
