How we can see table structure?
Answers were Sorted based on User's Feedback
What do you understand by active and passive transformations?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What is etl process? How many steps etl contains?
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
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?
What do you understand by the term ‘transformation’?
What is tracing level and what are the types?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
What are materialized views & where do we use them?
Do we need an ETL tool? When do we go for the tools in the market?