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
- 7790 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 are the guidelines to be followed while using union transformation?
Where is metadata stored?
How will the document be delivered to me?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How to elaborate powercenter integration service?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can you define user defied event?
What are the types of lookup transformation?
What are the different ways to implement parallel processing in informatica?
Briefly define reusable transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
pmscmd startworkflow -sv
What differs when we choose the sorted input for aggregator transformation?
Write the program through which the records can be updated?
How do you use reject loader.
