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 38228

What is incremental aggregation and how it is done?

JPMorgan Chase, TCS,

8 38837

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

Virtusa,

4 12993

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 6203

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

2 6464

Whatis the difference between View and Materialized View ?

Satyam, Syntel,

11 56435

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

IBM,

15 24747

what is casual dimension?

IBM,

6 19106

What is a diff between joiner and lookup transformation

CTS, Satyam, TCS, UHG,

16 95916

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

IBM,

4 11602

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 }

What are the conditions needed to improve the performance of informatica aggregator transformation?

1093

What are the popular informatica products?

1012

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

Why do we need informatica?

992

What is incremental aggregation?

1084

How to generate sequence numbers?

1088

How to convert multiple rows to single row (multiple columns) in informatica

1380

To import the flat file definition into the designer where should the flat file be placed?

1060

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1132

How to differentiate between the active and passive transformations?

1166

How many number of sessions can one group in batches?

1157

Can you use flat files in Mapplets.

2651

Explain the pipeline partition with real time example?

1144

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2036

For More Un-Answered { Informatica } Questions Click Here