1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

how do u decide whether u need to do aggregations at database level or at Informatica level?

 1 3620

how would u estimate the size of Lookup transform data and index cache?

 1 3235

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

 1 3791

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

 2430

how do u really know that paging to disk is happening while u are using a lookup transform?

 2049

how do u set partition points in the mapping?

Quintiles,

1802

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

 1 2941

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

 1639

what is meant by drill through?(Mascot)

 1 3337

what is pmrep command?

 1951

what happens if the info.server doesn't find the session parameter in the parameter file?

 2 4004

Can u access a repository created in previous version of Informatica?

DELL,

1 4795

Eliminating of duplicate records without using dynamic lookups

 1 3409

what are Lookup caches options? Including persistent caches.

 1 3928

Difference between flat files and relational sources?

 1770

Un-Answered Questions { Data Warehouse }

how the sas basic syntax style described? : Sas-administrator

608

What is ibm datastage?

609

How to calculate fact table granularity?

581

What could be a data source system?

581

Define pmcmd command?

625




Highlight the limitations of TPUMP Utility.

608

Does datastage support slowly changing dimensions ?

663

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2085

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1697

Where the data cube technology is used?

550

Explain is there any comparison available for cognos reportnet vs crystal reports?

547

What is the use of report studio?

613

What does update strategy mean, and what are the different option of it?

590

What is the maximum and minimum length of macro variable

657

What is database exceptions in teradata?

555

For More Un-Answered { Data Warehouse } Questions Click Here