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 8088

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

HP,

3 13579

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

TCS,

7 13316

what is the monster dimension plz give me one example

EDS,

2 9494

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

Cap Gemini, Target,

9 28137

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

Keane India Ltd,

5 20338

Which is costliest transformation? costly means occupying more memory?

3 10228

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 13374

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 4371

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

Accenture, Patni,

1 4897

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

1 4238

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

1987

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

2019

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 17470

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 5321

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is an unconnected transformation?

1035

Can u generate reports in Informatica?

1027

What are the main issues while working with flat files as source and as targets ?

1100

Define Pmrep command?

998

difference between informatica 8.1.1 and 8.6

3629

What is decode in static cache?

1082

What is a passive transformation?

1039

hi real timers . iam waiting for ur reply regarding ETL TESTING

2209

What are mapplets?

1214

What is data movement mode in Informatica and difference between them?

1066

Write the unconnected lookup syntax and how to return more than one column.

1051

How many ways are there to create ports?

1237

my source is junk data how will u remove that junk data by using unix please any one replay me

3652

Explain lookup transformation is active in informatica

1038

What is the advantage of informatica?

1016

For More Un-Answered { Informatica } Questions Click Here