Interested to Buy Any Domain ? << Click Here >> for more details...
Using Expression transformation how to remove duplicate
records from a relational source?
- 4 Answers
- 24641 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
In which transformation you cannot drag ports into it?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How do you update the records with or without using update strategy?
How to convert multiple rows to single row (multiple columns) in informatica
what are the deliverables?in your project?
What is the fact table?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Briefly explain the aggregator transformation?
What is joiner transformation?
Why union transformation is an active transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
What do you mean by filter transformation?
What is the cumulative sum and moving sum?
What is transformation?
