how to remove duplicates in transformer stage by using
stage variables?one example?
Answer Posted / venu
if you want to remove duplicates in transformer stage
use one of the partition technic hash partition you can
easily remove duplicatess
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
how can we create rank using datastage?what is the meaning of rank?
How do you schedule or monitoring the job?
What is datastage engine?
What is datastage?
What are stage variables?
Define meta stage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Can you highlight the main features of ibm infosphere information server?
Why fact table is in normal form?
What are stage variables and constants?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is the purpose of pivot stage?
options available in sequence job to run,validate?
What is the difference between operational data stage (ods) and data warehouse?