Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
- 2 Answers
- 10515 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How to open an older version of an object in the workspace?
Suppose we do not group by on any ports of the aggregator what will be the output?
As union transformation gives UNION ALL output, how you will get the UNION output?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Under which circumstances, informatica server creates reject files?
Define filter transformation?
What are the tasks that source qualifier perform?
What you know about transaction control transformation?
Design a mapping to load a target table with the following values from the above source?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain the different dimensions.
What is expression transformation?
explan ur project architecture?
What is a transaction control transformation?
