Can we call a stored procedure from a unix script which is run
using command task
- 1 Answers
- 6155 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the types of caches in lookup?
Explain about the concept of mapping parameters and variables ?
what is threshold error in informatica?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,
Explain the difference between mapping parameter and mapping variable?
Why touse stored procedure in ETL Application?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
How does a rank transform differ from aggregator transform functions max and min?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
without using emailtask how will send a mail from informatica?
how we can do session partition in informatica any one explain me clearly? thanks advance.
Teradata 
