Hi Friends,
I want lo truncate my records from target before loading
current month data,but i dont have permission to truncate
with truncate option
if u know any other way please give your valuable input for
this.
Thanks
Abhishek
Answer Posted / raj
Use delete * .... in pre-sql
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain dynamic target flat file name generation in informatica
Differences between version 7.x and 8.x.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Different circumstance which drives informatica server to expel records?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the main features of Oracle 8i with context to datawarehouse?
Which development components of informatica have the highest usage?
Enlist few areas or real-time situations where informatica is required.
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is native users?
How we can create indexes after completing the load process?
What are the types of presistent cache in look up tr.
What do think which one is the better joiner or look up?