Hi, how to delete duplicate values from table if source and target are

How to delete duplicate record in Informatica?

Question Posted / mayuresh

7 Answers
30578 Views
I also Faced
E-Mail Answers

Answer Posted / mayuresh

Hi,

how to delete duplicate values from table if source and
target are same

my Question is which logic we need to apply before using
DD_DELETE option in update strategy ?

Do we require to use aggregator to group the values and if
there count > 1 then DD_DELETE

PLZ reply

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is depict expression change?

1187

What is an aggregator transformation?

1142

lookup transformation with screenshots

4045

How big was your fact table

1855

Explain the shared cache and re-cache?

1162

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1094

Different qualification between a related rotate toward the sky and isolates look upward?

1033

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9286

What is the command used to run a batch?

1107

How to elaborate tracing level?

1217

Explain the etl program with few examples.

1110

Why do you use Mapping Parameter and mapping variable?

1803

What is difference between a gateway node and worker node?

1196

What are pre and post-session shell commands?

1377

what is informatica metadata?

1085