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 lookup transformation source types in informatica
What is data movement mode in Informatica and difference between them?
Write the advantages of partitioning a session?
Difference between Data and Index Caches?
Define filter transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain the pipeline partition with real time example?
What is mapping debugger?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Can anyone tell me the new features in Informatica 9 Version?
whats the logic to load the lower level of granularity of data to fact table.
Write the unconnected lookup syntax?
How we can create indexes after completing the loan process?
Differentiate between sessions and batches?
Explain the etl program with few examples.