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 pushdown optimization $pushdownconfig parameter - informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Enlist the advantages of informatica.
Separate from an archive server and a powerhouse?
How can you increase the performance in joiner transformation?
Can you generate sequence numbers without using the sequence generator transformation?
What is a rank transform?
What is meant by a domain?
What are the transformations that are not supported in mapplet?
What is informatica powercenter repository?
Differentiate between reusable transformation and mapplet.
Explain Dataware house architecture .how data flow from intial to end?
What are the advantages of using informatica as an etl tool over teradata?
EXL informatica Questions
What is the function of aggregator transformation?