How will you update the first four rows and insert next
four rows in a mapping?
Answer Posted / tejal
We can use an expression transform after the source quailifier - define a variable / counter port and increment it for each run.
Output this counter value and pass it to a router , which has 2 groups based on this value counter <=4 then insert else update.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
draw informatica architecture 8.6 ?
How can we handle two sessions in informatica?
scenario where i can use only concurrent execution of workflow.
How does the aggregator transformation handle null values?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Which version configuration tool used in ur project?
I have a flat file, want to reverse the contents of the flat file
What is the difference between router and filter?
Describe an informatica powercenter?
What is exclusive and normal mode for repository services?
Explain the pipeline partition with real time example?
Describe expression transformation?
can you please explain me pre session and post session options?
How you can differentiate between connected lookup and unconnected lookup?