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 / raj
Use delete * .... in pre-sql
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is informatica metadata?
What do you mean incremental aggregation?
Describe data concatenation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the guidelines to be followed while using union transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are multi-group transformations?
Quickly characterize reusable change?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is a sequence generator transformation?
What is the sql query overwrite in source qualifier in informatica
How can a transformation be made reusable?