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 6983Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
2 11514Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?
3 18646A 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 7573I 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 15224How 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 19274from 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 40012What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
1 5123difference between source based commit? and target based commit? which is better with respect to performance?
IBM,
6 19118Post New Informatica Questions
What are multi-group transformations?
What is main use of mapplet?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Why union transformation is an active transformation?
can we override a native sql query within informatica? Where do we do it?
Explain informatica architecture - version 8 / 9
How does the aggregator transformation handle null values?
How to generate sequence numbers without using the sequence generator transformation?
What is a passive transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How can repository reports be accessed without sql or other transformations?
What is an expression transformation?
How to configure mapping in informatica?
What if the source is a flat-file?
Why filter transformation is an active one?
