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
- 10857 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
Differences between version 7.x and 8.x.
What is dimensional table?
What are multi-group transformations?
Differentiate between a database and data warehouse?
How do you load only null records into target? Explain through mapping flow.
Can informatica load heterogeneous targets from heterogeneous sources?
What is a surrogate key?
What is the need for an etl tool?
What do you mean by blocking transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What all join we can perform in LOOKUP transformation?
Explain the use of aggregator cache file?
What you know about transaction control transformation?
What's the layout of parameter file (what does a parameter file contain?)?
draw informatica architecture 8.6 ?
