Informatica Interview Questions
Questions Answers Views Company eMail

What is hash partition?

1 7376

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 18174

What is the filename which you need to configure in UNIX while installing infromatica?

Accenture,

2 13651

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 4780

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 41156

why do u use shortcuts in informatica.?

iFlex,

4 27406

how do u move the code from development to production?

6 10745

what is confirmed dimension?

6 11796

Kimball and Inmon methodologies?

2 16007

star and snowflake schema?

6 11785

surrogate keys usage in Oracle and Informatica?

ITC Infotech, Oracle,

5 13757

scd methodology?

2 5210

version controlling in informatica?

3 16753

what r the values tht r passed between informatics server and stored procedure?

1 4620

what is parallel querying and what r hints.

1 4490


Post New Informatica Questions

Un-Answered Questions { Informatica }

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

615


Why union transformation is an active transformation?

643


can u any challenge your project?

1588


Enterprise data warehouse your projects phase by phase explain?

1440


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1718






Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

619


Explain why we use partitioning the session in informatica?

596


Explain the informatica workflow?

575


Where can we find the throughput option in informatica?

590


What is data transformation manager process?

610


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8502


Under which circumstances, informatica server creates reject files?

582


lookup transformation with screenshots

3545


How to use pmcmd utility command?

569


How to load last n records of file into target table - informatica

586