Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
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 |
What are the types of presistent cache in look up tr.
Can you start a batches with in a batch?
What are the settings that you use to configure the joiner transformation?
how to convert the .doc docs into .txt format using informatica
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
what are the difference between Informatica 7.1 and 8.1?
Explain the mapping variable usage example in informatica
can a port in expression transf be given the name DISTINCT
If u r using dynamic cache lookup port will be thier in thet which option u will select
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer