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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

 1498

with out using update strategy transnsformation how to update the data in mapping level

 1 4057

how to get the only updated records in the target

 2 4898

how to get flatfile containg 10 records half records one target another half another target

 2 4592

i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..

 1 2482

what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance

IBM,

2 6750

what is the difference between MOLAP and ROLAP?

 3 7625

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

 8 19868

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

Accenture,

6 10288

How to improve the session performance in informatica?

Accenture,

3 20113

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

 1556

how to import XTP files into SAS datasets?

Barclays, Institute For Plasma Research,

1 7653

how to import HTML files into SAS datasets?

HP,

3 14370

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

JPMorgan Chase,

2727

how can or from where we can get reference data in scd type2 implementation?

JPMorgan Chase,

2 6197

Un-Answered Questions { Data Warehouse }

Define data warehouse?

552

Why update strategy and union transformations are active? Explain with examples.

713

What is metric store database?

565

what is index?how it can work in informatica

1582

Can you explain players in datastage?

704




What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

580

What is the difference between union and union all in teradata?

618

How big was your fact table

1316

how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

1295

Define project in datastage?

662

What are the features of datastage flow designer?

633

Explain snowflake schema?

577

How many bi services node can be clustered together?

500

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1206

Explain the types of lookup transformation?

573

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