Interested to Buy Any Domain ? << Click Here >> for more details...
If we have 1000 rows were loaded in to datawarehouse and
next day the source have 1010 rows so, how can we loaded
only updated rows into target.
- 6 Answers
- 12134 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / babu
By selecting 'UPDATE else insert' in the 'Treat source rows
as :'from
session properties we can get updated rows and new rows..
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the tasks that can be performed using sq?
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
Which development components of informatica have the highest usage?
Where are the source flat files kept before running the session?
How are the sources and targets definitions imported in informatica designer?
How to open an older version of an object in the workspace?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is standalone command task?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is a predefined event?
Explain sessions. Explain how batches are used to combine executions?
What are the limitations of joiner transformation?
expain about the tune parameters?
What are the designer tools for creating transformations?
