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
- 10652 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 databases that informatica can connect to windows?
Is it possible to use a client with different version than that of its Informatica server?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is olap (on-line analytical processing?
What is a sequence generator transformation?
What is the Process to creating lookup transformation in informatica
What are the types of presistent cache in look up tr.
What are session parameters ? How do you set them?
What is the use of code page?
Explain sessions?
EXL informatica Questions
Can you use flat files in Mapplets.
What does reusable transformation mean?
