How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 9248 Views
- TCS, I also Faced
- E-Mail Answers
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 |
In dimension and fact table? which one holds big data?
Without using Lookup & Sequence Generator, How to generate Sequence?
How we will implement Pushdown Optimization and Types in Informatica with better examples
How the informatica server sorts the string values in Rank transformation?
What is difference between a connected look up and unconnected look up?
what are the differences between powercenter 8.1 and powercenter 8.5?
What is use of batch file in informatica? How many types of batch file in informatica?
how do u fnd the duplicate rows and how to delete the duplicate rows?
What is a command that used to run a batch?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
I want load the data into target with out 1st and last record.
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
Teradata 
