Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

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

What are set operators in Oracle

Deloitte, Wipro,

3 13586

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 this


9 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. Dynamic


21 26117

why sequence generator should not directly connected to joiner transformation ?


1 8842

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 3794

What is Target Update Override? What is the Use ?


8 14731

difference between source based commit? and target based commit? which is better with respect to performance?


6 15081

difference between shortcut and reusable transformation?

2 8163

Post New Informatica Questions

Un-Answered Questions { Informatica }

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