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 7669

what is target update override and when we use it?

TCS,

2 7016

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

TCS,

5 11077

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 4927

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 4518

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 26284

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,

2194

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 17457

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

TCS,

2 8733

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

TCS,

7 10404

differences between service based and product based?

Satyam,

2060

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 7372

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

Zensar,

2 11560

why we use materialized view over view?

Zensar,

1 5405

can session assigned multiple mappings or not?

Zensar,

2 8262

Post New Informatica Questions

Un-Answered Questions { Informatica }

How many types of sessions are there in informatica.please explain them?

1214

Make a note of the quantity vaults made in informatica?

1046

How can you define user defied event?

1079

What are session parameters ? How do you set them?

1901

How union transformation is used?

1059

What is an unconnected transformation?

1133

What are the different versions of informatica?

1338

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1153

what is informatica metadata?

1092

How to load last n records of file into target table - informatica

1137

Differentiate between a repository server and a powerhouse?

1188

What is an expression transformation?

1081

how to load rows into fact table in data warehouse

1235

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2153

have u done any performance tuning? how u ll do?

2370

For More Un-Answered { Informatica } Questions Click Here