Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

What are the two modes of datamovement in informatica sever?

2 5392

What is confirmed dimension and fact?

7 16137

What are reusable transformations in how many ways we can create them?

2 7530

What is facttable granularity?

2 6783

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

HeadStrong, TCS,

8 26965

What are the different types of schemas?

ITC Infotech,

11 81265

How to enter same record twice in the target table,explain?

7 10695

What are the different threads in DTM process?

2 8481

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 10843

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 33353

what are presession,postsession success and postsession failure commands ?

1 5695

What are mapping parametres and variables in informatica?


6 32136

What is source qualifier?


6 28494

What is the Difference between DSS & OLTP?

5 10311

Explain grouped cross tab?


1 12811

Post New Informatica Questions

Un-Answered Questions { Informatica }

How can we create index after completion of load process?


How do you promote a non-reusable transformation to reusable transformation?


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?


What is an unconnected transformation?


What is the Process to creating lookup transformation in informatica


What is aggregator transformation in informatica?


What is substr in informatica?


How to extract the informatica rejected data?


Is it possible to create multiple domains on a single Informatica server?


What is a filter transformation?


Briefly explain the aggregator transformation?


How can we use batches?


What are the tuning techniques you applied during your last project


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure


What is DR strategy for Informatica project?