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
- 12335 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
How do we call shell scripts from informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Does an informatica transformation support only aggregate expressions?
What is substr in informatica?
How can you validate all mappings in the repository simultaneously?
What differs when we choose the sorted input for aggregator transformation?
What are different types of transformations available in informatica?
In how many ways we can create ports?
Define the various join types of joiner transformation?
Differentiate between router and filter transformation?
Which files are created during the session rums by informatics server?
What is the difference between a repository server and a powerhouse?
How to join three sources using joiner?
Explain transaction control transformation in informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
