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 do u identify the changed records in operational data?
what are Lookup caches options? Including persistent caches.
what are the facilities provided by OLAP to analytical users?
what make u disappointmnets in u r career
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Identifying the bottlenecks in various components of Informatica and resolving them.
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?
Is apache nifi an etl tool?
how do u implement scheduling in Informatica?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
how do u set partition points in the mapping?
what are the reporting tools and difference between them?