Interested to Buy Any Domain ? << Click Here >> for more details...
we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.
- 8 Answers
- 11944 Views
- I also Faced
- E-Mail Answers
Answer Posted / ssrinivas624
any one heard about cume()function...
Using cume() funtction we can achieve this...
take any expresion after source qualifier add a row_cume
port and write an expression like cume(1)...
take a filter t/r write row_cume = 2 OR row_cume = 5 in
condition tab. Like any number of different rows u can
get...
two targets...
--->FILTER--->TARGET1
SQ--->EXP
--->FILTER--->TARGET2
same target...
SQ--->EXP--->FILTER--->TARGET
in the place of two filters u can go for router also...
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the conditions needed to improve the performance of informatica aggregator transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
can we override a native sql query within informatica? How do we do it?
Differences between version 7.x and 8.x.
What is aggregate cache in aggregator transformation?
wat are deployement groups in informatica, how it will be used for developers
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Make a note of the quantity vaults made in informatica?
update strategy transformation in informatica
How might one distinguish in the case of mapping is right or not without associating session?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is the function of aggregator transformation?
How to load a Dimension ? and how to load a fact table?
What are session parameters ? How do you set them?
Explain the difference between mapping parameter and mapping variable?
