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 |
whatis the default data driven operation in informatica
How will u pas the data with out debugger?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
what is sql override?what is the use of it?
What is informatica etl tool?
To achieve the session partition what r the necessary tasks u have to do?
what is difference between COM & DCOM?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
how can one eliminate dupliacte data with out using distinct option?
Enlist the differences between database and data warehouse.