| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: How good are you with your PL/SQL?
Answer: On the scale of 1-10 say 8.5-9 |
| July 07, 2008 10:25:04 |
#2 |
| padmanabhan.s |
Member Since: July 2008 Total Comments: 1 |
RE: How good are you with your PL/SQL?
|
| Though we dont write the PL/SQL directly, we can write a procedure or a fucntion which determines our needs and then can be called in the datastage ODBC or OCI stage using call() statement. For eg. if the procdeure name is xyz, then we can just call the procedure in the said stage as "call(xyz);" which will invoke the procedure and load the required tables used for the transformation. |
| |
Back To Question | |
