Using Expression transformation how to remove duplicate
records from a relational source?
- 4 Answers
- 23226 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
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
how we can load rejected record's at run time?(not through bad files)
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what is the complex transformation you used in informatica
Global and Local shortcuts. Advantages.
What does reusable transformation mean?
What are the differences between a connected lookup and unconnected lookup?
What are the different components of powercenter?
Differentiate between source qualifier and filter transformation?
What is difference between a gateway node and worker node?
Differentiate between a database and data warehouse?
What is a stored procedure transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is workflow? What are the components of the workflow manager?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
