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
- 10044 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 |
how can u handle null values in transformer stage.
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
what is set mapping in datastage??
Have you used Unstructured data?
How you Remove the Dataset in Unix?
How to read multiple files using a single datastage job if files have the same metadata?
What is the difference between validated and compiled in the datastage?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
how to implement scd2 in datastage 7.5 with lookup stage
What are stage variables, derivations and constants?
what is the use of invokation id
Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks
Teradata 
