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 5199

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

Cognizant,

1 3046

in performance wise union is past,union all is past

2 5348

in oracle write query yourname+1 from dual

5 7640

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 15642

what is the difference between stop and abort

2 5513

tell me about your project functionality

2311

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)

1896

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

1 3635

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

1930

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

1 4767

how to get the only updated records in the target

2 6163

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

2 5427

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 11979

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the code page compatibility?

1032

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1989

Mention a few design and development best practices for informatica?

953

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2094

What is mapping debugger?

966

explain one complex mapping with logic? sales project?

6623

can anyone explain me about retail domain project in informatica?

7902

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1040

Explain constraint based loading in informatica

1055

What does update strategy mean, and what are the different option of it?

1058

What do you understand by SOA of Informatica?

944

What is aggregate cache in aggregator transformation?

1087

How to create a non-reusable instance of reusable transformations?

1074

How to call shell scripts from informatica?

950

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2072

For More Un-Answered { Informatica } Questions Click Here