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 8093

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

HP,

3 13596

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

TCS,

7 13338

what is the monster dimension plz give me one example

EDS,

2 9502

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

Cap Gemini, Target,

9 28175

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

Keane India Ltd,

5 20360

Which is costliest transformation? costly means occupying more memory?

3 10236

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 13400

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 4385

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

Accenture, Patni,

1 4905

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

1 4242

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

1994

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

2026

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 17501

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 5325

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the new features of informatica 9.x in developer level?

943

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

954

What is the benefit of partitioning a session?

1112

Define pmcmd command?

997

Explain the use of aggregator cache file?

1197

Briefly explain the aggregator transformation?

949

Differentiate between Load Manager and DTM?

2098

What do you understand by SOA of Informatica?

933

What do you mean by blocking transformation?

980

what is the hint? how to use it to reduce the query processing in program?

7648

How to do unit testing in informatica? How to load data in informatica ?

1053

What is the benefit of session partitioning?

1056

What is the difference between STOP and ABORT options in Workflow Monitor?

1192

What is the Rank index port in Rank transformation?

1018

How to create or import flat file definition in to the warehouse designer?

1028

For More Un-Answered { Informatica } Questions Click Here