Follow Our FB Page << CircleMedia.in >> 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?

TCS,

6 32136

What is source qualifier?

SDS,

6 28494

What is the Difference between DSS & OLTP?

5 10311

Explain grouped cross tab?

Accenture,

1 12811


Post New Informatica Questions

Un-Answered Questions { Informatica }

How can we create index after completion of load process?

438


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

503


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

1485


What is an unconnected transformation?

481


What is the Process to creating lookup transformation in informatica

408






What is aggregator transformation in informatica?

383


What is substr in informatica?

477


How to extract the informatica rejected data?

577


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

550


What is a filter transformation?

413


Briefly explain the aggregator transformation?

432


How can we use batches?

455


What are the tuning techniques you applied during your last project

1389


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

6109


What is DR strategy for Informatica project?

496