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 24961

how can we calculate fact table size?

1 6336

how i will stop my workflow after 10 errors

HP,

2 6968

why we r using presql&postsql in source qualifier?

HP,

1 6117

how i will stop my workflow after 10 errors

HP,

1 6959

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

HP,

4 7537

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

HP,

3 5814

what is size of u r database?

2302

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

Oracle,

2 5956

what is the size of ur database(like oracle)

HP,

2 6282

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

HP,

1 5908

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

HP,

2267

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

Cap Gemini,

3700

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 25358

explan ur project architecture?

TCS,

2061

Post New Informatica Questions

Un-Answered Questions { Informatica }

How can we use mapping variables in informatica? Where do we use them?

1195

What is informatica?

1146

How to open an older version of an object in the workspace?

1198

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7442

How identifying bottlenecks in various components of informatica and resolving them?

1127

To import the flat file definition into the designer where should the flat file be placed?

1057

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1124

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2195

Explain what is informatica metadata and where is it stored?

1047

What happens when a session fails and you click on recover?

1116

What is the difference between source qualifier transformations source filter to filter transformation?

1043

What is rank transform?

991

How to load the data from people soft hrm to people soft erm using informatica?

1008

What are the different types of olap? Give an example?

1049

What is an Integration service in Informatica?

1128

For More Un-Answered { Informatica } Questions Click Here