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 |
what is the Default Source Option For Update Strategy Transformation?
Explain sessions and how many types of sessions are there?
what is the command to get the list of files in a directory in unix?
What are the challenges you have faced in your project?
What is standalone command task?
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How informatica process data means how informatica works?
How to eliminate duplicates in FF and oracle both
How you can differentiate between connected lookup and unconnected lookup?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,