What is limitations of truncate and load option
Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between router and filter transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is rank transform?
How you know when to use a static cache and dynamic cache in lookup transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the command used to run a batch?
What are junk dimensions?
if we have a delimiters at unwanted places in a flat file how can we over come those.
In development project what is the process to follow for an etl developer from day1
What is the surrogate key?
Explain your project of banking domian.
Differentiate between a database and data warehouse?
can anyone suggest best free Talend data integration training online
Design a mapping to load a target table with the following values from the above source?