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
- 18012 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
What is domain and gateway node?
What is an active transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
In which transformation you cannot drag ports into it?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
how tokens will generate?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is informatica metadata and where is it stored?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the databases that informatica can connect to windows?
What all join we can perform in LOOKUP transformation?
How to convert multiple rows to single row (multiple columns) in informatica
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How can we use mapping variables in informatica?
What are the advantages of using informatica as an etl tool over teradata?
