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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

For clinical entire study how many tables will create approx?

TCS,

1510

How to read data from flat file source if the data is in paragraph format?

Wipro,

2 3834

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

Wipro,

1904

How to set Parameter in Script data source?

 1 1710

How to create a cube in Transformer? What is the process? Please mention process thank u

Genpact,

1322

Unix command to view the data in a dataset

IBM,

2 5582

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

IBM, PR3 Systems,

4 5232

what is the difference between repository & Intergration service

 1 3668

hoe to access second value in mapping parameter if it is having more than one value ?????????????

SS Solutions,

1122

What is difference between merged dimension and forced dimension??

 1 4031

What is ROWID explain ?

Wipro,

2 3273

when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

 2 2453

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

 2 2849

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

 1309

Can we make worklet inside worklet?

 1 6090

Un-Answered Questions { Data Warehouse }

What is the function you would use to transfer a string into a decimal?

711

What are the design features involved in teradata?

537

How do you determine the number of sessions?

606

what is the use of sas management console? : Sas-di

601

Explain me ETL project architecture in Detail?

1914




Explain vproc in teradata?

555

What is slibref?

731

Differences between version 7.x and 8.x.

1404

What metadata importer can do in ab initio?

678

how you provide security to reports? How you provide security to packages ?

621

how many maximum session supports to multiload in teradata ??

1681

Mention what is the syntax for m_dump in abinitio?

950

What are the benefits of using microstrategy intelligence server?

560

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

1533

What is amazon redshift?

1

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