Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the unique records on multiple columns by using
sequential file stage only
- 3 Answers
- 9976 Views
- I also Faced
- E-Mail Answers
Answer Posted / todearhari
Just a small correction to Above Answer ,First we need to sort the Data then use the Uniq then only you will get Complete uniq records as uniq compares line by line.
Command:
Sort |Uniq
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Triggers,VIEW,Procedures
What are the primary usages of datastage tool?
Does datastage support slowly changing dimensions ?
What is the importance of the exception activity in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Define project in datastage?
what are the errors,warnings in datastage
Define orabulk and bcp stages?
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
Can you explain players in datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are the types of hashed files in data stage
What are the different kinds of views available in a datastage director?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Is it possible to query a hash file?
