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
- 11067 Views
- CTS, I also Faced
- E-Mail Answers
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
Where are the source flat files kept before running the session?
What is informatica? Why do we need it?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
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
What is a predefined event?
What are the differences between source qualifier and joiner transformation?
What is the use of code page?
Where do we use mapping variables in informatica?
How do we call shell scripts from informatica?
To import the flat file definition into the designer where should the flat file be placed?
How to convert multiple rows to single row (multiple columns) in informatica
draw informatica architecture 8.6 ?
Can we create a Integration service without a Repository service and vice versa?
How can we use mapping variables in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
