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
- 10068 Views
- Deloitte, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sudheer
answer for Q2, use sort stage and use generate change key column option. use filter stage to send all change key columns having value=1 to move in to a file which generates A B C D, and filter records having value=0 to another file which generates B B C.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / 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 |
Answer / nams
It can be done by unix uniq -u file_Name and uniq -d file_Name
or it can be done from datastage sequential file stage filter option from property.....write command overthere like above.....
| Is This Answer Correct ? | 1 Yes | 3 No |
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are stage variables and constants?
What are the types of views in datastage director?
Why we use surrogate key?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
what is main difference between change capture and change apply stages
How do you run datastage job from the command line?
What is the difference between validate and compile?
Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
What is the flow of loading data into fact & dimensional tables?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
Teradata 
