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 25195

how can we calculate fact table size?

1 6434

how i will stop my workflow after 10 errors

HP,

2 7073

why we r using presql&postsql in source qualifier?

HP,

1 6216

how i will stop my workflow after 10 errors

HP,

1 7049

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

HP,

4 7734

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

HP,

3 5950

what is size of u r database?

2367

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

Oracle,

2 6096

what is the size of ur database(like oracle)

HP,

2 6430

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

HP,

1 5997

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

HP,

2311

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

Cap Gemini,

3755

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 25951

explan ur project architecture?

TCS,

2129

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the fact table?

1141

Explain the different dimensions.

1010

explan ur project architecture?

2129

What does “tail –f” command do and what is its use as an Informatica admin.

1147

What are the advantages of informatica?

1061

What are the limitations of joiner transformation?

1182

 Informatica Checkpoints

3379

Different qualification between a related rotate toward the sky and isolates look upward?

1041

Which transformation should we use to normalise the COBOL and relational sources?

1274

When do you use sql override in a lookup transformation?

1143

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

2311

What will be the approach?

1039

What are the types of caches in lookup?

1096

What does update strategy mean, and what are the different option of it?

1143

Make a note of the quantity vaults made in informatica?

1046

For More Un-Answered { Informatica } Questions Click Here