How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
Answer Posted / 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 |
Post New Answer View All Answers
Can we create multiple integration service on single repository?
What is Data Caches size?
waht type of interface is used for testing the data in informatica
is it possible to index the data in cache of lkp transformation ?
What is the difference between stop and abort in informatica
Explain pushdown optimization and types in informatica
Differentiate between a database and data warehouse?
Is it possible to define a single node as a Gateway node as well as worker node?
Which development components of informatica have the highest usage?
What is the sequence generator transformation in informatica?
Implementation methodology
difference between informatica 8.1.1 and 8.6
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
what is the complex transformation you used in informatica
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?