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

Informatica Interview Questions

Questions Answers Views Company eMail

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

iFlex, TCS,

2 9266

How could we generate the sequence of key values without using sequence generator transformation in the target ??

TCS, Tech Mahindra,

12 38222

What is incremental aggregation and how it is done?

JPMorgan Chase, TCS,

8 38835

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

Virtusa,

4 12992

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 6201

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 6463

Whatis the difference between View and Materialized View ?

Satyam, Syntel,

11 56430

Without using any transformations how u can load the data into target?

IBM,

15 24743

what is casual dimension?

IBM,

6 19104

What is a diff between joiner and lookup transformation

CTS, Satyam, TCS, UHG,

16 95911

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

IBM,

4 11599

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com

2078

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 4321

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

2 23885

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

Satyam,

2 17904

Post New Informatica Questions

Un-Answered Questions { Informatica }

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

1106

lookup transformation with screenshots

4005

explan ur project architecture?

2067

Enlist the various types of transformations.

1057

Under which circumstances, informatica server creates reject files?

1094

What do you mean by worklet?

1064

What is the use of source qualifier?

1136

What is joiner transformation?

1010

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1203

What will be the approach?

979

Write the different tools in the workflow manager?

1064

What all are steps in up gradation of Informatica server?

1045

What is informatica powercenter repository?

1201

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1901

explain one complex mapping with logic? sales project?

6668

For More Un-Answered { Informatica } Questions Click Here