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
- 12565 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 the maplet?
Define the various join types of joiner transformation?
Sequence generator, when you move from develoment to production how will you reset
What are the different components of powercenter?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Do you find any difficulty while working with flat files as source and target?
What if the source is a flat-file?
server hot-ws270 is connect to Repository B. What does it mean?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is the fact table?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Why is sorter an active transformation?
What is a code page?
Which is the t/r that builts only single cache memory?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
