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 9250

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

TCS, Tech Mahindra,

12 38197

What is incremental aggregation and how it is done?

JPMorgan Chase, TCS,

8 38805

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

Virtusa,

4 12982

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 6196

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

2 6452

Whatis the difference between View and Materialized View ?

Satyam, Syntel,

11 56387

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

IBM,

15 24708

what is casual dimension?

IBM,

6 19085

What is a diff between joiner and lookup transformation

CTS, Satyam, TCS, UHG,

16 95875

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

IBM,

4 11578

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

2071

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

1 4316

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 23875

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

Satyam,

2 17887

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the advantage of informatica?

1065

What is joiner change?

1144

what are 3 tech challenges/ common issues you face?

2342

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. ?

2030

If informatica has its scheduler why using third party scheduler?

1257

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

1237

Define mapplet?

1006

Make a note of the quantity vaults made in informatica?

987

Can u generate reports in Informatica?

1080

Explain why we use partitioning the session in informatica?

1086

What is joiner transformation?

1008

which one is better performance wise joiner or look up

1086

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1280

Define joiner transformation?

1046

how tokens will generate?

2196

For More Un-Answered { Informatica } Questions Click Here