Interested to Buy Any Domain ? << Click Here >> for more details...
Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
- 2 Answers
- 11334 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajasekhar.
we can create a parameter file as previous_run_time and
current_run_time in the mapping. based on this time stamps
we can capture the new records which need to be insert and
update in the target table.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / amarnath
pass the records to the lokup transformation. u get a new
lookup port, pass this to router. in router 1st condition
newlookuprow =0 second newlookuprow =1. pass the "0" to
update strategy for update and pass the "1" to another
update strategy for insert.
| Is This Answer Correct ? | 4 Yes | 4 No |
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?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are ETL Tools?
in what type of scenario bulk loading and normal loading we use?
What are the joiner caches?
What is a joiner transformation and why it is an active one?
what is row level and column level indicator?
what are testing in a mapping level please give brif eplanation
I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..
What are the reusable transforamtions?
What are the components of Informatica? And what is the purpose of each?
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
Teradata 
