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
What are the performance considerations when working with aggregator transformation?
During the running session, output files are created by informatica server. Enlist few of them.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain the different lookup methods used in informatica?
How might one distinguish in the case of mapping is right or not without associating session?
Which development components of informatica have the highest usage?
Parameter and variable differences
What are the settings that you use to configure the joiner transformation?
What is meant by target load plan?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
COM components can be used in Informatica
What is resilience time?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Performance tuning in UNIX for informatica mappings?