How you load distinct records into one target and duplicate
records into another target?
- 3 Answers
- 15035 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
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Difference between Data and Index Caches?
difference between informatica 8.1.1 and 8.6
According to his methodology what all you need before you build a datawarehouse
Explain your project of banking domian.
State the differences between sql override and lookup override?
Which version configuration tool used in ur project?
What are the different ways to implement parallel processing in informatica?
What are active transformations.
Why update strategy and union transformations are active?
What is standalone command task?
What is informatica etl tool?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Describe data concatenation?
What is parallel processing in informatica?
