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
- 12326 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
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is option by which we can run all the sessions in a batch simultaneously?
What are the types of caches in lookup? Explain them.
What are the designer tools for creating transformations?
Is it possible to use a client with different version than that of its Informatica server?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is an active transformation?
Where are the source flat files kept before running the session?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How we can use union transformation?
To import the flat file definition into the designer where should the flat file be placed?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the main features of Oracle 8i with context to datawarehouse?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
where to store informatica rejected data?
