Answer / babu

u can write the filter condition in filter t/r.

in aggregator t/r select all ports are group by and add one
out put port,that is out--count(*),
in filter t/r u cam place the condition is out=1;

mapping:
src->sq->agg(t/r)->filtr or router t/r->trg

Answer / ramesh

this can achieved using Update statergy
we have option in UPD or Target update override

Answer / santosh kumar sarangi

1. If source is relational then in SQ you can check the
distinct or in mapping we can use distinct in sorter t/r.
2.if flat file then distinct in sorter t/r.

It will not allow nay duplicate data, so target will get
only distinct data.

Let me know if any thing wrong.

Thanks & regards
Santosh Kumar Sarangi

Answer / upendra

sq--> srtr-->aggr-->tgt

note:
srtr->properties->
select distinct and connect to aggr tr
aggr-->group by key column
aggr->properties->select sorted input
and connect to tgt

Answer / moorthy g [ibm]

1. Target Update Override
2. Select Unique Value (means)
Exp:
out_flag: decode( true, pre_no=no, 'Y', 'N')
pre_no = no

Router:
Out_flag: Y --- Unique Value
Default --- Duplicate Value

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

How many cubes create from a single model?

1 Answers  

What are the different versions of informatica?

0 Answers  

Separate from an archive server and a powerhouse?

0 Answers