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 5198

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

Cognizant,

1 3045

in performance wise union is past,union all is past

2 5347

in oracle write query yourname+1 from dual

5 7636

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 15637

what is the difference between stop and abort

2 5511

tell me about your project functionality

2310

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

1 3678

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

1894

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

1 3633

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

1928

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

1 4765

how to get the only updated records in the target

2 6161

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

2 5425

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 11976

Post New Informatica Questions

Un-Answered Questions { Informatica }

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2410

what is $$$$?

2107

How to start a workflow using pmcmd command?

1199

Explain sessions. Explain how batches are used to combine executions?

966

What are the types of lookup transformation?

1036

Describe an informatica powercenter?

1057

Which transformation is needed while using the Cobol sources as source definitions?

1141

What is mapplet in informatica?

999

What is transformation?

1061

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

1024

Define joiner transformation?

1003

In development project what is the process to follow for an etl developer from day1

1673

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2007

Could you explain what is enterprise data warehouse?

1077

Target increases every day even though no new record was inserted

1526

For More Un-Answered { Informatica } Questions Click Here