How will you update the first four rows and insert next
four rows in a mapping?
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
Explain the etl program with few examples.
How do you set a varible in incremental aggregation
What do you mean by worklet?
Differentiate between a database and data warehouse?
What are the different types of olap? Give an example?
What is a pre-defined event and user-defined event?
Enlist the various types of transformations.
Differentiate between Load Manager and DTM?
What is confirmed fact in dataware housing?
Did u used latest transformations of 8.6.0? for what?
What is decode in static cache?
Explain why we use partitioning the session in informatica?
What is the session task and command task?
What do you mean by blocking transformation?
What are the different components of powercenter?