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

 1493

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

 1 4048

how to get the only updated records in the target

 2 4882

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

 2 4579

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 2477

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 6742

what is the difference between MOLAP and ROLAP?

 3 7612

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 19831

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 10274

How to improve the session performance in informatica?

Accenture,

3 20086

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

 1550

how to import XTP files into SAS datasets?

Barclays, Institute For Plasma Research,

1 7640

how to import HTML files into SAS datasets?

HP,

3 14363

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,

2722

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

JPMorgan Chase,

2 6183

Un-Answered Questions { Data Warehouse }

How do you import and export data into datastage?

695

What are query items?

571

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1663

Target increases every day even though no new record was inserted

1103

What are the frequently used data types in teradata?

594




How we can call macros with in data step? : sas-macro

607

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4207

Explain the new features of teradata?

564

State the differences between shortcut and reusable transformation

513

What are the different servers in sas? : sas-grid-administration

596

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1614

How many areas for files does datastage have?

638

What are cluster in redshift? How do I create and delete a cluster in aws redshift?

1

What is difference between join, merge and lookup stage?

634

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1633

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