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
- 9055 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 informatica? Why do we need it?
Is it possible to create multiple domains on a single Informatica server?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How do you promote a non-reusable transformation to reusable transformation?
What are the different versions of informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Slowly changing dimensions, types and where will you use them
What the difference is between a database, a data warehouse and a data mart?
How many numbers of sessions can one group in batches?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are the different types of olap? Give an example?
How an expression transformation differs from aggregator transformation?
What is a node in Informatica?
can u give example for factless fact table
What are pre and post-session shell commands?
