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 6995Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
2 11525Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
3 18666A 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 7584I 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 15247How 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 19296from 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 40053What 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 19129Post New Informatica Questions
Mention a few design and development best practices for informatica?
How to load a Dimension ? and how to load a fact table?
What is joiner change?
What is data movement mode in Informatica and difference between them?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
State the differences between sql override and lookup override?
What is the function of aggregator transformation?
What is data transformation manager process?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain sessions and how many types of sessions are there?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is the maplet?
Performance tuning( what you did in performance tuning)
What does cheating measurement mean?
