why we r using presql&postsql in source qualifier?
Answer / amedela chandra sekhar
Presql :sql statement executed before the session retrive
the data from source.
Postsql:sql statement executed atfer the session retrive the
data from source.
| Is This Answer Correct ? | 10 Yes | 0 No |
Differentiate between Load Manager and DTM?
What are Target Options on the Servers?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
How can a transformation be made reusable?
what is the incremental agrrigation?
enterprise datawarehouse your project phase by phase explain?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is workflow? What are the components of workflow manager?
What are the databases that informatica can connect to windows?