Interested to Buy Any Domain ? << Click Here >> for more details...
What is the method of seperating unique and duplicate
records in session level?
- 2 Answers
- 10276 Views
- Emphasis, JBL, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jz
Select Distinct Box at Source propeties level or jus
override sql in Session.
| Is This Answer Correct ? | 17 Yes | 3 No |
Answer / priya yadav
Hi,
I am not aware at session level but I can tell you the same
at mapping level.
Either Select Distinct in SQ itself or in expression, u can
use a variable v1 to store the business keys of the
records. This will store the business keys(based on which
you have to determine a record as duplicate) of the record
v1= A||B||C
Assign this to another variable v2. This will assign these
business keys to v2.
v2=v1( Now v2 will have value A||B||C)
Set Duplicate Flag as Y if V1= V2 else N.
Now the business keys are stored in v2. Next time the
record will come it will calculate v1 on basis of business
keys, if that record is duplicate v1=v2, and record will be
marked for duplicate. If the record has different business
keys then v1 <> v2, and the record will not be marked as
dupliacte.
Hope it helps.
Thankyou!!
Priya Yadav
| Is This Answer Correct ? | 0 Yes | 0 No |
What is incremental aggregation?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
what is diffrence b/w joner and union transfermation
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
How does the aggregator transformation handle null values?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
Can we make worklet inside worklet?
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
What is difference between partioning of relatonal target and partitioning of file targets?
Limitation of REPLACESTR. Is there any character limitation to it.
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can we update a target table (without primarykey) by using update strategy transformation?
Teradata 
