Interested to Buy Any Domain ? << Click Here >> for more details...
How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 9837 Views
- TCS, I also Faced
- E-Mail Answers
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 is decode in informatica?
In informatica workflow manager, how many repositories can be created?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the function of look up transformation?
What is powercenter on grid?
What is the difference between informatics 7x and 8x and what is latest version?
What are the differences between joiner transformation and source qualifier transformation?
What is a joiner transformation?
How to load the data from people soft hrm to people soft erm using informatica?
explan ur project architecture?
How do you load unique records into one target table and duplicate records into a different target table?
how tokens will generate?
What is a repository? And how to add it in an informatica client?
What does command task mean?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
