Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

How to load last 10 records of flat file in to the target?

iNautix,

5 24720

how can we calculate fact table size?

1 6229

how i will stop my workflow after 10 errors

HP,

2 6868

why we r using presql&postsql in source qualifier?

HP,

1 6015

how i will stop my workflow after 10 errors

HP,

1 6885

I have source like this 1:2;3. so i want to load the target as 123

HP,

4 7366

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

HP,

3 5689

what is size of u r database?

2251

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

Oracle,

2 5852

what is the size of ur database(like oracle)

HP,

2 6130

what is the size of u r project? and what is the size of source file?

HP,

1 5812

what is the size of u r source(like file or table)?

HP,

2202

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

Cap Gemini,

3652

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

Cap Gemini, IBM,

16 24792

explan ur project architecture?

TCS,

2007

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain your project of banking domian.

1611

Did u used latest transformations of 8.6.0? for what?

1826

Define Pmrep command?

999

How will the document be delivered to me?

1021

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2282

What does cheating measurement mean?

998

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

1066

What is different between the data warehouse and data mart?

1003

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1273

What is transformation?

1053

Have you worked with/created Parameter file

1616

What is a passive transformation?

1040

How do you change a non-reusable transformation to reusable transformation?

948

generate date / time dimension in informatica

1073

What is the advantage of informatica?

1016

For More Un-Answered { Informatica } Questions Click Here