Follow Our FB Page << CircleMedia.in >> 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.

BirlaSoft,

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

Deloitte,

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

Deloitte,

21 26117

why sequence generator should not directly connected to joiner transformation ?

ANZ,

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 ?

Patni,

8 14731

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

IBM,

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?

216


What do mean by local and global repository?

264


What is Cognos script editor?

3367


What are the advantages of using informatica as an etl tool over teradata?

204


in reporting we add some new objects,how we get the count of the newly added objects to the report

1374






Clarify the aggregator change?

221


Write the advantages of partitioning a session?

239


What is primary and backup node?

278


How can you generate reports in informatica?

220


Briefly describe lookup transformation?

238


What is the Rank index port in Rank transformation?

258


Explain sql transformation in script mode examples in informatica

249


What is depict expression change?

226


What is domain and gateway node?

241


can u give example for factless fact table

4471