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
- 16062 Views
- CSC, I also Faced
- E-Mail Answers
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
What is exclusive and normal mode for repository services?
Explain the different lookup methods used in informatica?
What are the types of schemas we have in data warehouse.
Can we create a Integration service without a Repository service and vice versa?
server hot-ws270 is connect to Repository B. What does it mean?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the types of data warehouses?
How do you handle two sessions in Informatica
To import the flat file definition into the designer where should the flat file be placed?
How is union transformation utilized?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How do you load alternate records into different tables through mapping flow?
wf dont have integration severances how you can run?
pmscmd startworkflow -sv
Explain sessions. Explain how batches are used to combine executions?
