How to load the data into target table, which not have Primary/Surrogate key (

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)

Question Posted / akash2110

5 Answers
10243 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records no..

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

Is This Answer Correct ?

4 Yes

0 No

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records no..

Answer / ramesh

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

Is This Answer Correct ?

3 Yes

1 No

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records no..

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

Is This Answer Correct ?

1 Yes

0 No

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records no..

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

Is This Answer Correct ?

0 Yes

0 No

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records no..

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

Is This Answer Correct ?

0 Yes

1 No

Post New Answer