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 5350

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

Cognizant,

1 3162

in performance wise union is past,union all is past

2 5543

in oracle write query yourname+1 from dual

5 7960

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 15803

what is the difference between stop and abort

2 5768

tell me about your project functionality

2383

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

1 3854

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

1984

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

1 3759

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

2074

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

1 4914

how to get the only updated records in the target

2 6377

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

2 5664

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 12351

Post New Informatica Questions

Un-Answered Questions { Informatica }

Describe data concatenation?

1127

What is the difference between informatica 7.0 and 8.0?

1054

What is InformaticaPowerCenter?

1179

Difference between Data and Index Caches?

1209

Explain the use of aggregator cache file?

1323

What is the difference between a connected look up and unconnected lookup?

1005

Is stop and abort are same in informatica?

1050

What do you mean by channel change?

1113

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

1274

Explain the code page compatibility?

1123

Is there any way to read the ms excel datas directly into informatica?

1073

What is the sequence generator transformation in informatica?

1268

What the difference is between a database, a data warehouse and a data mart?

1203

How many ways are there to do 'remove duplicate records in informatica'?

1067

Performance tuning in UNIX for informatica mappings?

2625

For More Un-Answered { Informatica } Questions Click Here