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?
- 0 Answers
- 1660 Views
- I also Faced
- E-Mail Answers
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
Hi, Lookup() is what kind of join ?
what are the types in error loging?
how do u really know that paging to disk is happening while u are using a lookup transform?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
what is data modeling?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
State the differences between shortcut and reusable transformation
what are business components in Informatica?
What are the ETL Testing Operations?
how do u extract data from different data sources explain with an example?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
Teradata 
