Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / obulreddy.b
IT IS A TRANSFORMATION WHICH IS USED TO PERFORM DML
OPERATIONS ON ALREADY DATA POPULATED TARGETS.
GENERALLY INFORMATICA SERVER WILL TREAT SOURCE ROWS AS
INSERT. IF WE USE UPDATE STRATOGY TRANSFORMATION WE HAVE TO
SELECT TREAT SOURCE ROWS AS DATADRIVEN IN SESSION
PROPERTIES, NOW INFORMATICA SERVER DRIVES THE DATA AS PER
UPDATE STRATOGY VALUE.
WE HAVE TO SELECT UPDATE STRATOGY VALUE BASED ON OUR
REQUIREMENT.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain the informatica workflow?
What is the sql query overwrite in source qualifier in informatica
Does an informatica transformation support only aggregate expressions?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is data movement mode in Informatica and difference between them?
Briefly define reusable transformation?
Mention few advantages of router transformation over filter transformation.
complex mapping ur project u r invlve can u explain and give real time example give me ?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How do you load first and last records into target table?
what is the -ve test case in your project.
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 is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the use of transformation?
