Interested to Buy Any Domain ? << Click Here >> for more details...
Create a job to load all unique products in one table and the duplicate rows in to another table.
The first table should contain the following output
A
D
The second target should contain the following output
B
B
B
C
C
Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table.
The first table should contain the following output
A
B
C
D
The second table should contain the following output
B
B
C
- 3 Answers
- 10192 Views
- Deloitte, IBM, I also Faced
- E-Mail Answers
Answer Posted / unknown
Q1: First use Aggregate stage- Row Count property then filter stage to separate Row Count 1 and more than 1.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Triggers,VIEW,Procedures
What are routines in datastage? Enlist various types of routines.
Define Job control?
Highlight the main features of datastage?
What are the functionalities of link partitioner and link collector?
What are the various kinds of the hash file?
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 is apt_config in datastage?
Is the value of staging variable stored temporarily or permanently?
Distinguish between informatica & datastage. Which one would you choose and why?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How will you move hashed file from one location to another location?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
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)
Define repository tables in datastage?
