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 5438

in oracle write query yourname+1 from dual

5 7803

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 5627

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 3691

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

2001

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 6267

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 12161

Post New Informatica Questions

Un-Answered Questions { Informatica }

update strategy transformation in informatica

1064

What is blocking transformation?

1144

What is the Rank index port in Rank transformation?

1061

What is a sequence generator transformation?

1021

Suppose we do not group by on any ports of the aggregator what will be the output?

1041

What is a filter transformation?

1043

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

what is size of u r database?

2305

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2251

What is sorter transformation?

1046

Explain the different lookup methods used in informatica?

1042

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1153

What are the different lookup cache(s)?

1118

What are the uses of etl tools?

1128

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1199

For More Un-Answered { Informatica } Questions Click Here