1)first sort d data in accending order based on date and remove duplica

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

Question Posted / rajesh

2 Answers
6500 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

Please Help Members By Posting Answers For Below Questions

Difference between data warehousing and olap?

1097

How the ipc stage work?

1139

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1503

Lookup constraints

1264

explain about citrix scheduling tool in datastage

2462

how do u catch bad rows from OCI stage? And what CLI stands for?

2801

How complex jobs are implemented in datstage to improve performance?

1043

Differentiate between datastage and informatica?

1188

what is ds administrator used for?

1175

What steps should be taken to improve Datastage jobs?

1075

What are the primary usages of datastage tool?

1075

What could be a data source system?

1024

How rejected rows are managed in datastage?

1526

Explain the situation where you have applied SCD in your project?

2041

Describe the main features of datastage?

1078