Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 18083 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / krishnakanth
If the informatia user id does not have permissions to
truncate the table in the database. Then there is no other
way we can truncate the table.
Anyways try with this option. Try to write a pre-sql
statement in the session. So that first the sql statement
will execute and then the session will start executing
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What all are steps in up gradation of Informatica server?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How does the aggregator transformation handle null values?
what is the complex transformation you used in informatica
Where are the source flat files kept before running the session?
How to start a workflow using pmcmd command?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the new features of Power Center 5.0?
How are indexes created after completing the load process?
What is primary and backup node?
what is size of u r database?
How to implement security measures using repository manager?
Explain the types of transformations?
