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
- 1454 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
when will use SQL override in a lookup transformation?
What are dimensions?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
What is initial load and what is full load?
What are the differences between sql override and update override?
Identifying the bottlenecks in various components of Informatica and resolving them.
how do u decide whether u need to do aggregations at database level or at Informatica level?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
how does the server recongnise the source and target databases.Elaborate on this
What is tracing level? How many types of transformations supported by sorted input?
Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com
320 Answers Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
Teradata 
