how to remove duplicates in transformer stage by using
stage variables?one example?
Answer Posted / amit
using hash partition technique, we can bring duplicate data(based on key columns) in one partition. Then in stage constraints filter out data with setting @inrownum = 1.
This will remove duplicate in transformer stage.
Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How many types of views are there in a datastage director?
What are the types of containers?
Where the datastage stored his repository?
How to read the length of word in unix?
What is the difference between datastage and informatica?
Terminate Activity
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is the process of killing a job in datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Is it possible to query a hash file?
What are the types of hashed files in data stage
What is the difference between informatica and datastage?
What are the main features of datastage?
What are the processing stages?