Interested to Buy Any Domain ? << Click Here >> for more details...
How you load distinct records into one target and duplicate
records into another target?
- 3 Answers
- 16792 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / shaik
Create a mapping with two targets.
> Create an Aggregator transformation and group it on the
distinct values and load it into Target1.
> Load the data directly in to Target2 since the source
have duplicates it will load all the duplicates.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the use of code page?
which one is better performance wise joiner or look up
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the mapping parameters and mapping variables?
where to store informatica rejected data? How to extract the informatica rejected data?
Why do you use Mapping Parameter and mapping variable?
what are the deliverables?in your project?
how to create user defined function (udf) in informatica
What is a sorter transformation?
What is decode in static cache?
What is persistent lookup cache?
How to update or delete the rows in a target, which do not have key fields?
Do you find any difficulty while working with flat files as source and target?
Target increases every day even though no new record was inserted
