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
Mention a few design and development best practices for informatica?
How to load the data from people soft hrm to people soft erm using informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Briefly define reusable transformation?
Explain the etl program with few examples.
What are the designer tools for creating transformations?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the new features of informatica 9.x developer?
where to store informatica rejected data?
What is dimensional table?
Explain incremental aggregation in informatica
Where can we find the throughput option in informatica?
What is standalone command task?
What is xml source qualifier transformation in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?