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
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are multi-group transformations?
Explain lookup transformation source types in informatica
Define update strategy?
Explain the different kinds of facts.
What is the cumulative sum and moving sum?
Explain the etl program with few examples.
What is intricate mapping?
What is the difference between STOP and ABORT options in Workflow Monitor?
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
Can we create multiple integration service on single repository?
list out all the transformations which use cache?
What is a grid in Informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is source qualifier transformation in informatica?