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

Informatica Interview Questions

Questions Answers Views Company eMail

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 6334

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 15571

whatis the default data driven operation in informatica

2 6736

How to generate a single mapping for both the historical and incremental load.

CSC, TATA,

2 8365

How to eliminate 1st and last rows from the source and load the inbetween rows.

Syntel,

5 25940

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 5171

What are the uses of a Parameter file?

CSC,

3 13421

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 6385

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 7059

List the transformation in informatica.

TCS,

1 12227

where does the default group roew in a router is stored what is the default size of memory in router

1 4974

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 6374

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

Deloitte, TCS,

3 17623

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

Deloitte,

3 26108

What is the difference between IN and Exists in Oracle?

Deloitte,

4 18054

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the difference between mapping parameter and mapping variable?

982

How does a rank transform differ from aggregator transform functions max and min?

1147

What is meant by pre and post session shell command?

1107

How to implement security measures using repository manager?

1084

What are mapplets?

1213

What are the prerequisite tasks to achieve the session partition?

1180

What do you mean by filter transformation?

904

Why do you use Mapping Parameter and mapping variable?

1682

How many transformations can be used in mapplets.

1874

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

2058

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4678

Enlist the differences between database and data warehouse.

1035

What is the function of union transformation?

1067

What is the meaning of decode in informatica?

1076

What does role playing dimension mean?

999

For More Un-Answered { Informatica } Questions Click Here