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
- 12244 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 is event and what are the tasks related to it?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How can we update a record in the target table without using update strategy?
Explain dynamic target flat file name generation in informatica
What is the session task and command task?
what is size of u r database?
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
What are the new features of informatica 9.x developer?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a predefined event?
How to start a workflow using pmcmd command?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is meant by incremental aggregation?
Differentiate between reusable transformation and mapplet.
What do you mean by channel change?
