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 7547

what is target update override and when we use it?

TCS,

2 6927

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

TCS,

5 10895

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 4441

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 26146

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,

2135

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 17310

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

TCS,

2 8624

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

TCS,

7 10205

differences between service based and product based?

Satyam,

2020

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 7245

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

Zensar,

2 11450

why we use materialized view over view?

Zensar,

1 5309

can session assigned multiple mappings or not?

Zensar,

2 8158

Post New Informatica Questions

Un-Answered Questions { Informatica }

COM components can be used in Informatica

2397

What are the different transaction levels available in transaction control transformation?

1211

What are the measure objects?

1211

What are mapplets?

1281

How can we store previous session logs?

1090

What is lookup change?

1055

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1637

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.

2201

What if the source is a flat-file?

1119

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

Explain about cumulative Sum or moving sum?

1045

Explain the different kinds of facts.

987

How many ways a relational source definition can be updated and what are they?

1019

How to elaborate powercenter integration service?

1138

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2129

For More Un-Answered { Informatica } Questions Click Here