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
- 8918 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
On which interface you will be working as a developer?
Why we use surrogate key?
How can we improve performance of data stage jobs?
how to sort two columns in single job in datastage.
What are transforms and what is the differenece between routines and transforms?
What is merge stage?
root tree will find which is server job and which is parallel job?
Can you implement SCD2 using join, transformer and funnel stage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
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 is the flow of loading data into fact & dimensional tables?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is a merge?
Difference between data warehousing and olap?
Can we use target hash file as a lookup ?
