Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 6904

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

2 11346

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

3 18484

How i can upload the MainFrame source For Informatica ?

1 9886

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

2 11723

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 7395

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 15041

What are set operators in Oracle

Deloitte, Wipro,

3 16964

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 19015

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 39350

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 10647

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

1 5012

What is Target Update Override? What is the Use ?

Patni,

8 19506

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

IBM,

6 18907

difference between shortcut and reusable transformation?

2 9975


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the Rank index port in Rank transformation?

1017


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1812


How does the aggregator transformation handle null values?

1091


According to his methodology what all you need before you build a datawarehouse

1698


What could be the possible resons of locks by user?

1039


What are the uses of etl tools?

1072


What is the use of target designer?

986


How can we handle two sessions in informatica?

985


Whats the difference between informatica powercenter server, repositoryserver and repository?

1122


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4680


How we can create indexes after completing the loan process?

1146


Quickly characterize reusable change?

1066


What is meant by active and passive transformation?

1036


What is Session and Batches?

1045


Explain the mapping variable usage example in informatica

1091