1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category
ETL Interview Questions
Questions Answers Views Company eMail

what are the facilities provided by data warehouse to analytical users?

 1658

what are the facilities provided by OLAP to analytical users?

 1 4048

what is HISTOGRAM? how to generate statistics?

 1 4163

how do u set the size of block buffer?

 1 3731

how do u implement unconn.stored proc. in a mapping?

 1 4131

if u can't find what you are looking for in lookup table, how do you handle?

 1 4611

How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

 1 5388

Which type or t/s is used to convert rows into column & column into rows

Infosys,

9 26871

In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

Accenture,

3 7768

Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,

320 217258

Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

 1794

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 6076

Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

 2 6004

architural difference between 7.1 workflow monitor and 8.1 workflow monitor.

IBM, Infosys,

1 2782

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

 2037

Post New ETL Questions

Un-Answered Questions { ETL }

What is full load & incremental or refresh load?

674

if i have a query as flat file how can we load data to target table

963

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

1676

what are the production issues in datastage?

9719

What is tracing level? How many types of transformations supported by sorted input?

533




Explain the difference between etl tool and olap tools?

527

A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?

1441

what are the facilities provided by data warehouse to analytical users?

1658

How to fine tune mappings?

556

Can there be sub steps of etl steps?

521

How to delete data which is not in source table?

822

what are the concerns of OLTP and DSS systems?

1549

What is data modeling and data mining?

544

Can we create Hierarchies in generic datasources?

1910

what is the meaning of upgradation of Repository?

3286

For More Un-Answered { ETL } Questions Click Here