Can we call a stored procedure from a unix script which is run
using command task
Answer / prabhu
Yes.we can.Use sqlplus -s command in unix to connect to
oracle from unix.Then we can execute the stored proc.
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 4 Yes | 0 No |
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
In which circumstances that informatica server creates Reject files?
Whatis the difference between View and Materialized View ?
How to run a session, which contains mapplet?
How to use Normalizer transformation?
What is Performance tuning in Informatica?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
Performance tuning( what you did in performance tuning)
How to convert multiple rows to single row (multiple columns) in informatica