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
- 17775 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / raj
Use delete * .... in pre-sql
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
difference between informatica 8.1.1 and 8.6
What does cheating measurement mean?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is DR strategy for Informatica project?
Can we create a node as a gateway node and the same node can be assigned to a grid?
hi real timers . iam waiting for ur reply regarding ETL TESTING
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 is a connected transformation?
Where can we find the throughput option in informatica?
whats the logic to load the lower level of granularity of data to fact table.
Which files are created during the session rums by informatics server?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
