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
- 12310 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
wf dont have integration severances how you can run?
How can we use batches?
Explain the informatica workflow?
How to handle decimal places while importing a flatfile into informatica?
How to go to the older version for a mapping?
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
Define filter transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the different versions of informatica?
What are the data movement modes in informatica?
How to create or import flat file definition in to the warehouse designer?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How do you convert single row from source into three rows into target?
What is deployment group?
Explain the shared cache and re-cache?
