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 8309

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

HP,

3 13921

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

TCS,

7 13882

what is the monster dimension plz give me one example

EDS,

2 9721

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

Cap Gemini, Target,

9 28805

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

Keane India Ltd,

5 20774

Which is costliest transformation? costly means occupying more memory?

3 10515

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 13883

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 4572

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

Accenture, Patni,

1 5075

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

1 4426

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

2109

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

2119

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 17944

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 5464

Post New Informatica Questions

Un-Answered Questions { Informatica }

Briefly define a session task?

1198

How to call shell scripts from informatica?

1044

Explain sessions?

1141

Which are the different editions of informatica powercenter that are available?

1084

draw informatica architecture 8.6 ?

3933

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1323

How to open an older version of an object in the workspace?

1270

How does a sorter cache works?

1110

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1143

What is the surrogate key?

1367

Explain lookup transformation is active in informatica

1151

Separate from an archive server and a powerhouse?

1011

How to convert multiple rows to single row (multiple columns) in informatica

1429

What you know about transaction control transformation?

1061

What is difference between a gateway node and worker node?

1204

For More Un-Answered { Informatica } Questions Click Here