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

Informatica Interview Questions

Questions Answers Views Company eMail

how we can update a target table without update strategy and update override?

TCS,

3 7537

what is target update override and when we use it?

TCS,

2 6919

select count(1) from emp? what is the o/p?

TCS,

5 10879

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

IBM,

1 4848

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

Infosys, Saksoft,

1 4438

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

IBM, Patni, TCS,

3 26141

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

Infotech,

2131

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

CompuSoft, EDS, TCS,

4 17299

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

TCS,

2 8613

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

TCS,

7 10182

differences between service based and product based?

Satyam,

2014

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

Satyam,

3 7239

Can we insert ,update ,delete in target tables with one update strategy tran.?

Zensar,

2 11442

why we use materialized view over view?

Zensar,

1 5303

can session assigned multiple mappings or not?

Zensar,

2 8148

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to use pmcmd utility command?

1032

What are the components of Informatica? And what is the purpose of each?

1055

What are the issues you have faced in your project? How did you overcome those issues?

2365

Differences between connected and unconnected lookup?

1218

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2199

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2036

What is update strategy transform?

1103

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

What are the new features of Power Center 5.0?

1779

Differences between version 7.x and 8.x.

1894

How to generate sequence numbers?

1088

What do you mean by filter transformation?

951

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1132

Explain why we use partitioning the session in informatica?

1093

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675

For More Un-Answered { Informatica } Questions Click Here