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
Explain the different lookup methods used in informatica?
Is it possible to create multiple domains on a single Informatica server?
How to open an older version of an object in the workspace?
Explain the different dimensions.
what is the size of your data warehousing?
difference between repository database and repository service?
What all join we can perform in LOOKUP transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the modules in Power Center
Briefly define a session task?
Explain in detail scd type 2 through mapping.
How many ways a relational source definition can be updated and what are they?
What are multi-group transformations?
what is diff b/t sorter t/r and agg have the option sorter property...
What is meant by incremental aggregation?