1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
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 6175

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

 2 10162

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

 3 17276

How i can upload the MainFrame source For Informatica ?

 1 9270

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

 2 10928

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 5809

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 13423

What are set operators in Oracle

Deloitte, Wipro,

3 15777

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 16555

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 33899

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 9775

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

 1 4357

What is Target Update Override? What is the Use ?

Patni,

8 16776

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

IBM,

6 17120

difference between shortcut and reusable transformation?

 2 9003

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the restrictions of union transformation?

565

How do you update the records with or without using update strategy?

651

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1622

What is domain and gateway node?

683

What is the need of etl tools?

595




Is it possible to revert a global repository to local one and why?

604

Is stop and abort are same in informatica?

561

Differentiate between router and filter transformation?

601

Design a mapping to load the cumulative sum of salaries of employees into target table?

886

What are the types of presistent cache in look up tr.

1538

What are the types of schemas we have in data warehouse and what are the difference between them?

512

 Informatica Checkpoints

2847

What is Data Caches size?

648

Difference between Data and Index Caches?

643

What does command task mean?

600

For More Un-Answered { Informatica } Questions Click Here