Interested to Buy Any Domain ? << Click Here >> for more details...
How will you update the first four rows and insert next
four rows in a mapping?
- 5 Answers
- 11072 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / shyam
from source qualifier trf take a exp trf with a sequence gen
and from there give it to filer trf. write there a condition
next value<=4 and give it to update stategy trk. and there
give condion as dd_insert and then to targer,this all comes
in first pipeline.
in second pipeline drag the ports from exp trf and again
take a filter trf,over there give condion as next_val>4 and
next_val<9. give this to update trf and then to targer.
try this .i hope u vl get the o/p.
if im wrong plz let me know
shaym
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What are the features of complex mapping?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to extract the informatica rejected data?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How do you promote a non-reusable transformation to reusable transformation?
What are active transformations.
what is SDLC way of code development?
Mention some types of transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the command used to run a batch?
what is index?how it can work in informatica
How can we update a record in the target table without using update strategy?
What is event and what are the tasks related to it?
