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
- 12167 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
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the prerequisite tasks to achieve the session partition?
How many input parameters can exist in an unconnected lookup?
what is unit testing?tell me proceedure
waht type of interface is used for testing the data in informatica
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Tell me about MD5 functions in informatica
How many numbers of sessions can one group in batches?
What is update strategy transform?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to create or import flat file definition in to the warehouse designer?
What is incremental aggregation?
What is deployment group?
what is the -ve test case in your project.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
