Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

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 7088

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 11675

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 18840

How i can upload the MainFrame source For Informatica ?

1 10074

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 11992

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 7725

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 15427

What are set operators in Oracle

Deloitte, Wipro,

3 17230

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 19588

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 40730

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 10826

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

1 5215

What is Target Update Override? What is the Use ?

Patni,

8 20080

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

IBM,

6 19327

difference between shortcut and reusable transformation?

2 10230

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to generate sequence numbers using expression transformation?

1152

How can informatica be used for an organization?

1276

How many number of sessions can one group in batches?

1220

What are the types of schemas we have in data warehouse.

1008

What is expression transformation?

1147

What is mapping debugger?

1070

Enlist the differences between database and data warehouse.

1166

What all join we can perform in LOOKUP transformation?

1024

What are the informatica performance improvement tips

1152

Is there any target staging area in informatica not staging area

2634

Under what condition selecting sorted input in aggregator may fail the session?

1176

What is a rank transform?

1148

what are the deliverables?in your project?

2198

Explain sessions and how many types of sessions are there?

1061

What is meant by pre and post session shell command?

1203

For More Un-Answered { Informatica } Questions Click Here