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

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

More Informatica Interview Questions

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,


how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,


how DTM buffer size and buffer block size are related

3 Answers   Wipro,


if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  


where to select code page option?

2 Answers   TCS,


How can we use mapping variables in informatica?

0 Answers  


How do you implement configuration management in Informatica?

1 Answers  


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

6 Answers   Puma,


Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  


What are set operators in Oracle

3 Answers   Deloitte, Wipro,


Where are the source flat files kept before running the session?

0 Answers   Informatica,


Categories