Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
1 6904Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
2 11346Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
3 18484A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
4 7395I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
5 15041How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
9 19015from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
21 39350What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
1 5012difference between source based commit? and target based commit? which is better with respect to performance?
IBM,
6 18907Post New Informatica Questions
What is the Rank index port in Rank transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How does the aggregator transformation handle null values?
According to his methodology what all you need before you build a datawarehouse
What could be the possible resons of locks by user?
What are the uses of etl tools?
What is the use of target designer?
How can we handle two sessions in informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How we can create indexes after completing the loan process?
Quickly characterize reusable change?
What is meant by active and passive transformation?
What is Session and Batches?
Explain the mapping variable usage example in informatica