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 9132

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

TCS, Tech Mahindra,

12 37780

What is incremental aggregation and how it is done?

JPMorgan Chase, TCS,

8 38489

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

Virtusa,

4 12836

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 6113

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

2 6359

Whatis the difference between View and Materialized View ?

Satyam, Syntel,

11 56071

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

IBM,

15 24242

what is casual dimension?

IBM,

6 18908

What is a diff between joiner and lookup transformation

CTS, Satyam, TCS, UHG,

16 95335

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

IBM,

4 11453

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

2031

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

1 4257

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 23753

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

Satyam,

2 17748

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are active transformations.

1605

Name the different lookup cache(s)?

1168

Enlist the tasks for which source qualifier transformation is used.

991

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2002

if we have a delimiters at unwanted places in a flat file how can we over come those.

1994

Define update strategy?

1127

How many ways are there to create ports?

1250

Differences between version 7.x and 8.x.

1852

is it possible to index the data in cache of lkp transformation ?

1969

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2002

What happens when a session fails and you click on recover?

1075

How can repository reports be accessed without sql or other transformations?

1166

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1036

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1961

What is informatica metadata and where is it stored?

942

For More Un-Answered { Informatica } Questions Click Here