Hi This is Vijay,
How can your remove the duplicates in sequential File?
Answer Posted / rajesh
Go to Sequential File and then Select Filter Property
Set Filter = sort|uniq...........
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the differences between datastage and informatica?
Describe the main features of datastage?
What are the repository tables in datastage?
What are system variables and sequencers in datastage
What are transforms and what is the differenece between routines and transforms?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What is a quality stage in datastage tool?
What are the types of views in datastage director?
Does datastage support slowly changing dimensions ?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
How many types of hash files are there?
Notification Activity
How will you move hashed file from one location to another location?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What are the various kinds of containers available in datastage?