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
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 |
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 |
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 |
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 |
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 |
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 .
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
how DTM buffer size and buffer block size are related
if soource is having 10 records how will u insert 20 records to target
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
where to select code page option?
How can we use mapping variables in informatica?
How do you implement configuration management in Informatica?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
Can yoU use the maping parameters or variables created in one maping into another maping?
What are set operators in Oracle
Where are the source flat files kept before running the session?