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 24991

how can we calculate fact table size?

1 6340

how i will stop my workflow after 10 errors

HP,

2 6978

why we r using presql&postsql in source qualifier?

HP,

1 6134

how i will stop my workflow after 10 errors

HP,

1 6965

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

HP,

4 7549

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

HP,

3 5831

what is size of u r database?

2311

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

Oracle,

2 5969

what is the size of ur database(like oracle)

HP,

2 6297

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

HP,

1 5916

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

HP,

2272

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

Cap Gemini,

3704

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 25401

explan ur project architecture?

TCS,

2069

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a joiner transformation?

997

What is informatica powercenter repository?

1202

Explain the shared cache and re-cache?

1119

What is a surrogate key?

1083

What is the scenario which compels informatica server to reject files?

1070

What is option by which we can run all the sessions in a batch simultaneously?

1143

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1581

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325

Explain the aggregator transformation?

1166

How to load data in informatica ?

1022

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953

Define mapping and session?

1037

Explain lookup transformation source types in informatica

1098

Explain your project of banking domian.

1652

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251

For More Un-Answered { Informatica } Questions Click Here