Interested to Buy Any Domain ? << Click Here >> for more details...
my source like dis
10,asd,2000
10,asd,2000
10,asd,2000
20,dsf,3000
20,dsf,3000
20,dsf,3000
like dis and my requirement is first record is inserted into
first target and duplicates of first record is inserted into
second target ...like dis way ...?
how to achieve dis?
- 4 Answers
- 9336 Views
- Mind Tree, Polaris, I also Faced
- E-Mail Answers
Answer Posted / chandra
take 2 agg Trs after SQ and drag all the ports to both the
AGG Trs and enable group by for all ports for one AGG and
take one output port in second AGG ..,in that take count(no)
then take filter and write condition as count(no)>1
SQ---->AGG(enable all ports group by)-->Tar1
---->AGG(count(no))-->FIL(count(no)>1)--->Tar2
| Is This Answer Correct ? | 11 Yes | 8 No |
Post New Answer View All Answers
Explain how many types of dimensions are available in informatica?
What is decode in static cache?
What are the types of caches in lookup? Explain them.
Under what conditions selecting sorted input in aggregator will still not boost session performance?
explain one complex mapping with logic? sales project?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Define update strategy?
What does cheating measurement mean?
How many number of sessions can one group in batches?
What are the different lookup cache(s)?
What are the uses of etl tools?
What is mapplet in informatica?
How to create a non-reusable instance of reusable transformations?
What is status code in informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?
