AGGREGATOR default datatype
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between account and directory options ?
how to closeing records after 10,000 records come?
What are the stages in datastage?
what r the stages mostly used in realtime scenarios
specify data stage strength?
How do you reject records in a transformer?
Explain how a source file is populated?
What is merge stage?
What is usage analysis in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .
can explain wt is the pool for file.