Hi This is Vijay,
How can your remove the duplicates in sequential File?
Answer Posted / chowdary
in sequntial file options filter--> sort | uniq -d
this will give best performence to remove duplicates.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
how do u catch bad rows from OCI stage? And what CLI stands for?
How rejected rows are managed in datastage?
how many rows sorted in sort stage by default in server jobs
How complex jobs are implemented in datstage to improve performance?
Differentiate between datastage and datastage tx?
How can we improve performance of data stage jobs?
Can you explain kafka connector?
Define project in datastage?
What are iconv and oconv?
How many types of hash files are there?
options available in sequence job to run,validate?
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?
Have you have ever worked in unix environment and why it is useful in datastage?
What is the difference between informatica and datastage?