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
In informatics server which files are created during the session rums?
without table how to come first record only in oracle?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What does “tail –f” command do and what is its use as an Informatica admin.
how to load dimension table and fact table. plz tell me the steps.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the features of complex mapping?
In which transformation you cannot drag ports into it?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is substr in informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are pre and post-session shell commands?
What is Data Caches size?
Explain the informatica workflow?
What is the meaning of decode in informatica?