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?
No Answer is Posted For this Question
Be the First to Post Answer
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
Explain about etl data integration software?
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 are the different etl testing categories as per their function?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
What is meant by incremental load?
Can there be sub steps of etl steps?
What are the various tools used in etl?
where is the cache (lookup, index) created and how can you see it.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
what are the concerns of OLTP and DSS systems?
Can u access a repository created in previous version of Informatica?