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
- 9338 Views
- Mind Tree, Polaris, I also Faced
- E-Mail Answers
Answer Posted / ramakrishna
SQ---->AGGR(CREATE O/P PORT AS RCOUNT)WRITE EXPRESSION AS
COUNT(EMPNO)SELECT GROUPBY TO EMPNO
---->ROUTER(GRP1- TRUE)--- TRG1
(GRP2-RCOUNT>1)--TRG2
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Have you worked with/created Parameter file
How can you validate all mappings in the repository simultaneously?
Can we create multiple integration service on single repository?
How can we use mapping variables in informatica? Where do we use them?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Define Pmrep command?
What are the types of caches in lookup?
What is meant by query override?
What does command task mean?
what is INFORMATICA TESTING process
What are junk dimensions?
What is the command used to run a batch?
What are data-driven sessions?
How to generate sequence numbers using expression transformation?
