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 / ravi
in the warehouse designer,in targets ,in generate and
execute option truncate the table
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Mention some types of transformation?
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?
What is session task and command task?
What is a surrogate key?
Sequence generator, when you move from develoment to production how will you reset
What can we do to improve the performance of informatica aggregator transformation?
What is the format of informatica objects in a repository?
What is olap (on-line analytical processing?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
explain one complex mapping with logic? sales project?
Which transformation should we use to normalise the COBOL and relational sources?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
can you please explain me pre session and post session options?
What is the use of source qualifier?
hi real timers . iam waiting for ur reply regarding ETL TESTING