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
- 9551 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 meant by pre and post session shell command?
What is the scenario which compels informatica server to reject files?
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
What is resilience time?
what is index?how it can work in informatica
Explain dynamic target flat file name generation in informatica
Which development components of informatica have the highest usage?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What does “tail –f” command do and what is its use as an Informatica admin.
What does role playing dimension mean?
How does a rank transform differ from aggregator transform functions max and min?
Why update strategy and union transformations are active?
Define update strategy?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How to elaborate powercenter integration service?
