Hi,
I have one flatfile as target in a mapping . When i am
trying to load data second time into it.
The records already is in flatfile is getting override. I
don't want to override existing records.
Note : we can do this by implementing CDC / Incremental pool
logic if target is relational .
But this is flatfile. So, even i use this same technique it
will override only
So what is the solution ?
Is there any option at session level for flatfile target ?
Advance Thanks
Answer Posted / krish
there is an option like APPEND IF EXISTS in session
properties
Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are batches?
What are the types of schemas we have in data warehouse and what are the difference between them?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Can we create two repositories on same database instance in oracle?
What is a connected transformation?
Scheduling properties,whats the default (sequential)
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How do you promote a non-reusable transformation to reusable transformation?
Enterprise data warehouse your projects phase by phase explain?
What are the components of the workflow manager?
How many input parameters can exist in an unconnected lookup?
what is the hint? how to use it to reduce the query processing in program?
Differences between connected and unconnected lookup?
What is the difference between a connected look up and unconnected lookup?