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 8188

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

HP,

3 13752

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

TCS,

7 13588

what is the monster dimension plz give me one example

EDS,

2 9595

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

Cap Gemini, Target,

9 28479

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

Keane India Ltd,

5 20550

Which is costliest transformation? costly means occupying more memory?

3 10365

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 13664

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 4455

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

Accenture, Patni,

1 4981

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

1 4324

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

2069

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 17715

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 5393

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1259

how we can load rejected record's at run time?(not through bad files)

2374

Define joiner transformation?

1046

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1995

What do you mean by worklet?

1063

can u any challenge your project?

2029

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

3699

Enlist the various types of transformations.

1048

What are multi-group transformations?

1087

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

968

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

1123

Is there any target staging area in informatica not staging area

2576

How can we handle two sessions in informatica?

1029

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

1254

What is workflow monitor?

1057

For More Un-Answered { Informatica } Questions Click Here