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 7536

what is target update override and when we use it?

TCS,

2 6918

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

TCS,

5 10875

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 26139

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 17297

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

TCS,

2 8612

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

TCS,

7 10176

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 11441

why we use materialized view over view?

Zensar,

1 5301

can session assigned multiple mappings or not?

Zensar,

2 8143

Post New Informatica Questions

Un-Answered Questions { Informatica }

where to store informatica rejected data? How to extract the informatica rejected data?

1005

How to configure mapping in informatica?

1173

What is rank transform?

996

Enlist some properties of sessions.

1067

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2120

what is unit testing?tell me proceedure

2221

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2356

What are the types of data warehouses?

1526

what is diff b/t sorter t/r and agg have the option sorter property...

2171

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7449

what is $$$$?

2157

permutations of mapplet

2511

What is the use of code page?

1092

How do you load unique records into one target table and duplicate records into a different target table?

1257

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1766

For More Un-Answered { Informatica } Questions Click Here