Data Warehouse Interview Questions
Questions Answers Views Company eMail

Why sorter is an active transformation?

Informatica,

894

Under which circumstances, informatica server creates reject files?

Informatica,

762

Explain the pipeline partition with real time example?

Informatica,

818

What is the need of an ETL tool?

Informatica,

797

What are the types of lookup transformation?

Informatica,

791

Explain pushdown optimization and types in informatica

Informatica,

802

What is a sorter transformation?

Informatica,

839

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

Informatica,

958

What is a connected transformation?

Informatica,

834

what is the Default Source Option For Update Strategy Transformation?

Informatica,

920

Can we use the mapping parameters or variables created in one mapping into another mapping?

Informatica,

1 1798

What are connected or unconnected transformations?

Informatica,

792

How can a transformation be made reusable?

Informatica,

800

Can u generate reports in Informatica?

Informatica,

785

What is the Process to creating lookup transformation in informatica

Informatica,

733


Un-Answered Questions { Data Warehouse }

What are different types of joins that are possible in obiee rpd?

600


Explain rw document?

801


What are situations where snowflake schema is better than star schema when the opposite is true?

693


when will use SQL override in a lookup transformation?

2004


Explain which are the olap tools available that are supported by oracle?

685






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

1861


How would you get two images on microstrategy login page?

676


Can the administrator easily maintain and manage microstrategy intelligence server?

678


How many numbers of sessions can one group in batches?

764


Explain the teradata primary index mechanics in detail with a diagram.

699


Define Merge?

1036


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

718


What are initial page components of Cognos connection?

756


What are stage variables, derivations and constants?

834


what are the deliverables?in your project?

1834