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 7390

what is target update override and when we use it?

TCS,

2 6798

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

TCS,

5 10677

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 4764

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 4366

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 26004

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,

2083

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 17149

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

TCS,

2 8501

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

TCS,

7 9948

differences between service based and product based?

Satyam,

1979

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 7122

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

Zensar,

2 11352

why we use materialized view over view?

Zensar,

1 5220

can session assigned multiple mappings or not?

Zensar,

2 8030

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the differences between a connected lookup and unconnected lookup?

1027

what is INFORMATICA TESTING process

2250

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1070

State the limitations where we cannot use joiner in the mapping pipeline?

1016

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1532

What are the informatica performance improvement tips

1039

According to his methodology what all you need before you build a datawarehouse

1720

How to open an older version of an object in the workspace?

1158

Where can we find the throughput option in informatica?

1020

update strategy transformation in informatica

1033

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1123

How do you update the records with or without using update strategy?

1074

How do you manage the Parameter files while migrating your data from one environment to another environment?

978

What if the source is a flat-file?

1061

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8177

For More Un-Answered { Informatica } Questions Click Here