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
- 12221 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 can informatica be used for an organization?
Which development components of informatica have the highest usage?
draw informatica architecture 8.6 ?
lookup transformation with screenshots
Design time, run time. If you don't create parameter what will happen
What are the main features of Oracle 8i with context to datawarehouse?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
permutations of mapplet
Can informatica load heterogeneous targets from heterogeneous sources?
How big was your fact table
What is a rank transform?
What the difference is between a database, a data warehouse and a data mart?
What do you mean by worklet?
