Interested to Buy Any Domain ? << Click Here >> for more details...
How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 31027 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ram mohan reddy
we can do this process by 2 ways ....
1)by dynamic lookup option in lookup(new lookup row) we can
load duplicate rows in one target table and unique rows in
one target table
do to this we need to have router transformation (add to
group ports one is for unique(new lookup row=1) and other is
for duplicate(new lookup row =2))after the lookup trans.
2)we can perform this by aggregator transformation using
coutnt(*) >1 for duplicate rows .here also we need to use
router transformion.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is an active transformation?
What are some examples of informatica etl programs?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are roles and groups and benefits of using them?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
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.
What are the modules in Power Center
What does command task mean?
What are the various types of transformation?
How can we improve session performance in aggregator transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to generate or load values in to the target table based on a column value using informatica etl tool.
can we override a native sql query within informatica? How do we do it?
Can we create multiple integration service on single repository?
How can you validate all mappings in the repository simultaneously?
