Interested to Buy Any Domain ? << Click Here >> for more details...
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 6994Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
2 11524Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
3 18664A 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 7583I 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 15245How 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 19294from 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 40047What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
1 5125difference between source based commit? and target based commit? which is better with respect to performance?
IBM,
6 19126Post New Informatica Questions
What is primary and backup node?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to create or import flat file definition in to the warehouse designer?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is an expression transformation in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Could you explain what is enterprise data warehouse?
How you prepared reports for OLAP?
What is sorter transformation?
How are indexes created after completing the load process?
Target increases every day even though no new record was inserted
How can we delete duplicate rows from flat files?
How might one distinguish in the case of mapping is right or not without associating session?
Difference between Target-based loading and constraint-based loading?
