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
- 10104 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandu
in sequential file there is one option is there i.e
filter.in this filter we use unix commands like what ever we
want.in this question we use uniq command in filter.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Whats difference betweeen operational data stage (ods) and data warehouse?
What is the difference between datastage and informatica?
Which algorithm you used for your hashfile?
Define project 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
Explain the situation where you have applied SCD in your project?
What is ds designer?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the different type of jobs in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
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
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the different kinds of views available in a datastage director?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is a merge?
