Using Expression transformation how to remove duplicate
records from a relational source?
Answers were Sorted based on User's Feedback
Answer / prathibha
Hi,
Source->SQ->Sorter->Expression->FilterTarget.
Lets take a small example for this scenario.
Use a sorter to sort the input data.
ID Name
1 A
1 A
2 B
3 C
3 C
In Expression Transformation declare the following ports:
ID
Name
O_Count= iiF(V_port=ID,O_Count=O_count+1,O_Count=0)
V_port(Variable Port) = ID;
In filter transformation give the condition O_Count =0;
Let me know if there are any suggestions.
Is This Answer Correct ? | 17 Yes | 2 No |
Answer / babu
Hi,
SRC-->SQ(ENABLE DISTINCT )-->EXP-->TRG
OR
IN EXP T/R TAKE 4 VARIABLE PORTS AND OUTPUT PORT,
SRC HAVEING THE COLUMNS LIKE COL1,COL2,COL3
SRC-->SQ-->SRT(PLEASE TAKE ALL ARE KEY PORTS)-->EXP
(VAR IS IIF(VAR1=COL1 AND VAR2=COL2 AND
VAR3=COL3),1,0)
VAR1=COL1
VAR2=COL2
VAR3=COL3
OUT=VAR
-->UPD(IIF(OUT=1,DD_REJECT,DD_INSERT))-->TRG
IF ANY THING WRONG PLEASE LET ME KNOW.
8861145051
Is This Answer Correct ? | 6 Yes | 9 No |
Answer / bijay
The mapping should be like this
SRC->SQ->EXP->TARGET
In source qualifier transformation select 'ENABLE DISTINCT',
then it will send only distinct record to the expression transformtion. And From expression transformation simply connect to the target
Is This Answer Correct ? | 2 Yes | 5 No |
How to create Target definition for flat files?
Can we insert ,update ,delete in target tables with one update strategy tran.?
What is the reusable transformation?
What is aggregate awareness?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
What are the phases in SDLC?
What is A complex mapping?
how can import the data from the flat files?
what is degenerated dimension?
Mention a few design and development best practices for informatica?
in which situations do u go for scds ?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?