How to delete the data in the target table after loaded.
Answer Posted / davankumar p
we have the property in session truncate option.
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
What are the advantages of using informatica as an etl tool over teradata?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the measure objects?
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
What is an unconnected transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How many dimensions are there in informatica?
Implementation methodology
What is sequence generator transformation in informatica?
How to create the source and target database connections in server manager?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What are multi-group transformations?
What are the basic requirements to join two sources in a source qualifier transformation using default join?