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

Informatica Interview Questions

Questions Answers Views Company eMail

What are the challenges of Dataware housing in the future?

HP,

2 8197

Which gives the more performance when compare to fixed width and delimited file ? and why?

HP,

3 13769

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

TCS,

7 13615

what is the monster dimension plz give me one example

EDS,

2 9612

how to run 2 workflows sequentially. plz respond what is the process?

Cap Gemini, Target,

9 28521

how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

Keane India Ltd,

5 20573

Which is costliest transformation? costly means occupying more memory?

3 10372

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

TCS,

7 13681

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 4458

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

Accenture, Patni,

1 4990

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 4330

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

2049

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

2071

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

Accenture, HCL,

6 17737

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 5399

Post New Informatica Questions

Un-Answered Questions { Informatica }

Why union transformation is an active transformation?

1047

What are the tuning techniques you applied during your last project

2026

what is degenerated dimension?

3996

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2182

How do you handle two sessions in Informatica

1164

Why do you use Mapping Parameter and mapping variable?

1763

Difference between Target-based loading and constraint-based loading?

1000

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

1081

can we override a native sql query within informatica? Where do we do it?

1122

I have a flat file, want to reverse the contents of the flat file

1127

Explain informatica architecture - version 8 / 9

1089

How can a transformation be made reusable?

1168

What is dimensional table? Explain the different dimensions.

1172

Define sessions in informatica etl?

1034

What is meant by pre and post session shell command?

1159

For More Un-Answered { Informatica } Questions Click Here