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

Informatica Interview Questions

Questions Answers Views Company eMail

we have to use order by,where,having we to implement sql query

Satyam,

1 5266

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

Cognizant,

1 3099

in performance wise union is past,union all is past

2 5436

in oracle write query yourname+1 from dual

5 7802

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

Cap Gemini, TCS, Wipro,

1 15714

what is the difference between stop and abort

2 5626

tell me about your project functionality

2341

tell me 7.x and 8.x diferrencess(but not transformations)

1 3753

tell me the rules and responsblites in our project(my project is development)

1933

tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 3689

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2000

with out using update strategy transnsformation how to update the data in mapping level

1 4831

how to get the only updated records in the target

2 6265

how to get flatfile containg 10 records half records one target another half another target

2 5532

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

Accenture,

6 12160

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the pipeline partition with real time example?

1143

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280

Briefly describe lookup transformation?

1046

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

1208

How can we remove the duplicates from flat file source?

1038

Design a mapping to load a target table with the following values from the above source?

1346

How to update source definition?

1087

What is the use of transformation?

996

how to load rows into fact table in data warehouse

1188

Why union transformation is an active transformation?

1047

What is the session task and command task?

1054

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1083

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2356

What is the sequence generator transformation in informatica?

1183

Do you find any difficulty while working with flat files as source and target?

1098

For More Un-Answered { Informatica } Questions Click Here