what is pre and post sql and what is diff between source
presql and target pre sql
Answer / priyaraj
Pre SQL means that the integration service runs SQL
commands against the source database before it reads the
data from source.
Post SQL means IS runs SQL commands against target database
after it writes to the target.
Is This Answer Correct ? | 26 Yes | 3 No |
How to jion 2 tables, without using any condition?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
if soource is having 10 records how will u insert 20 records to target
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
can any one explain me about junk dimension
Is snow flake or star schema used? If star schema means why?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
what is the size of your data warehousing?
tell me 5 session failure in real time how can you solve that in your project?
Where are the source flat files kept before running the session?
What is the difference between OLTP and ODS?