What is the method of seperating unique and duplicate
records in session level?
- 2 Answers
- 9165 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 scd?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
Which is the t/r that builts only single cache memory?
How can we delete duplicate rows from flat files?
when we go for unconnected lookup transformation? and why?
Can we use the mapping parameters or variables created in one mapping into another mapping?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
Why we use lookup transformations?
what is Partitioning ? where we can use Partition?
What is the difference between warehouse key and surrogate key?
Teradata 
