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
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 |
What are the tasks that Loadmanger process will do?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Enterprise data warehouse your projects phase by phase explain?
Make a note of the quantity vaults made in informatica?
What are Rapid changing dimensions?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...
if the session fails after 100 records agian we have to starts the session or we go for recovery session
what is informatica metadata?
What is aggregate cache in aggregator transforamtion?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
what is shared Cache. when we will use shared Cache?