What is limitations of truncate and load option
Answer / abhinaw prakash
You cannot rollback the data in case of failed session.
In this scenario you need to write delete query(delete from
tablename) and uncheck the Truncate target table option.
| Is This Answer Correct ? | 13 Yes | 0 No |
what is mean by throghput? in informatica
can we have to do changes in session property when we are dynamically generating target files?
What are mapplets? How is it different from a Reusable Transformation?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
How many ways are there to create ports?
What is facttable granularity?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
How to Join Tables my Source is having 15 table target is one?
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.
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
r u done any partitions in ur project?