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 5473
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.2 9239
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?3 16201
How i can upload the MainFrame source For Informatica ?1 8498
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?2 9986
A 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 4591
I 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 11364
How 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 this9 13165
from 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. Dynamic21 26117
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?1 3794
difference between source based commit? and target based commit? which is better with respect to performance?
difference between shortcut and reusable transformation?2 8163
What are the differences between oltp and olap?
What do mean by local and global repository?
What is Cognos script editor?
What are the advantages of using informatica as an etl tool over teradata?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Clarify the aggregator change?
Write the advantages of partitioning a session?
What is primary and backup node?
How can you generate reports in informatica?
Briefly describe lookup transformation?
What is the Rank index port in Rank transformation?
Explain sql transformation in script mode examples in informatica
What is depict expression change?
What is domain and gateway node?
can u give example for factless fact table