what is plsql table?
Answers were Sorted based on User's Feedback
Answer / nagaraju bhatraju
A PL/SQL table is a one-dimensional, unbounded, sparse
collection of homogeneous elements, indexed by integers. In
technical terms, it is like an array
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sandeep
From Oracle 8 onwards PLSQL table is an Associative Array
| Is This Answer Correct ? | 0 Yes | 0 No |
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
What is aggregate cache in aggregator transformation?
what is degenerated dimension?
what is the complex transformation you used in informatica
what is procedure to use mapping variable in source qualifier transformation? with example
Write the advantages of partitioning a session?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
Hey I am net to informatica? Can any one explain me step by step How scd will work ?