what r the values tht r passed between informatics server
and stored procedure?
Answer / sai suresh
There are 3 types of data passing between informatica
server and stored proceduer these are
Input/Output parametors: Stored procedure it receive the
inputs and porvied the outputs.
Return Value:Ever data base to provied return value after
processing of stored procedure.
Status code: It is used for error handling.
|Is This Answer Correct ?||2 Yes||0 No|
How to Create a folder using pmrep command?
In how many ways we can create ports?
What is mapplet and a reusable transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
what is filelist concept in informatica
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
What are the differences between a connected lookup and unconnected lookup?
What is CHECK-IN CHECK-OUT. Please explane me?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what is the size of ur database(like oracle)
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records