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
- 18082 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sunil
Abhishek Bhai,
Possible Solution:-
1. While creating connection, use such a generic id, which
have all the permission on DB objects. This way you
definitely can play with your Target object.
2. If no such credential available then, Delete and commit
process can be implemented in pre-sql.. but process will
become very slow (depends on volume of data).
Cheers !
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / venky
in target table u can write pre-sql statement as truncate
table tablename
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ravi
in the warehouse designer,in targets ,in generate and
execute option truncate the table
| Is This Answer Correct ? | 0 Yes | 3 No |
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
Why use the lookup transformation ?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
How to read data from flat file source if the data is in paragraph format?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What are the methods for creating reusable transforamtions?
What are the types of data warehouses?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
how to load duplicate row in a target
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
How an expression transformation differs from aggregator transformation?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
Teradata 
