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 8196

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

HP,

3 13766

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

TCS,

7 13608

what is the monster dimension plz give me one example

EDS,

2 9611

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

Cap Gemini, Target,

9 28516

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

Keane India Ltd,

5 20571

Which is costliest transformation? costly means occupying more memory?

3 10371

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 4989

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 17736

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 5398

Post New Informatica Questions

Un-Answered Questions { Informatica }

permutations of mapplet

2511

Enlist some properties of sessions.

1067

What is incremental aggregation?

1083

What is session task and command task?

1294

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

In which transformation you cannot drag ports into it?

1320

Which files are created during the session rums by informatics server?

1179

What is exclusive and normal mode for repository services?

1144

How can repository reports be accessed without sql or other transformations?

1218

What is a rank transform?

1084

Which is the t/r that builts only single cache memory?

1190

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1075

What is the function of aggregator transformation?

1084

What is meant by pre and post session shell command?

1159

Explain the types of transformations?

1066

For More Un-Answered { Informatica } Questions Click Here