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
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 some prerequisites for datastage?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
What is the method of removing duplicates, without the remove duplicate stage?
I am getting input value like X = Iconv(ā31 DEC 1967ā,āDā)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().
What is merge stage?
What are the types of views in datastage director?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
Where do the datastage jobs get stored?
Define orabulk and bcp stages?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
What are the functionalities of link partitioner and link collector?