Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Post New Answer

More ETL Interview Questions

How to increase performance without changing anything in mapping.( In prod)

0 Answers   IBM, Saama Tech, Wipro,


Explain about etl data integration software?

0 Answers  


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.?

0 Answers  


What are the different etl testing categories as per their function?

0 Answers  


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

0 Answers   Accenture,


What is meant by incremental load?

0 Answers  


Can there be sub steps of etl steps?

0 Answers  


What are the various tools used in etl?

0 Answers  


where is the cache (lookup, index) created and how can you see it.

0 Answers  


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?

1 Answers  


what are the concerns of OLTP and DSS systems?

0 Answers  


Can u access a repository created in previous version of Informatica?

1 Answers   DELL,


Categories