without update strategy how to insert &update?
Answer / nivas
First you create the mapping according to your requirement
after that you create session.
Double click the session and then select properties tab in
the properties tab choose Target Rows Source as what do you
want (Insert, update,delete, Datadriven(this is only when
your using update stratogy transformation in the mapping)).
| Is This Answer Correct ? | 6 Yes | 0 No |
What do you mean by enterprise data warehousing?
How does the server recognize the source and target databases. Elaborate on this.
wht is full process of Information source to target just like stg to productuon and development
HOW TO YOU LOAD TIME DIMENSION
difference between repository database and repository service?
Differentiate between sessions and batches?
Enlist the various types of transformations.
What are the different transaction levels available in transaction control transformation?
How to get EVEN & ODD numbers separately?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is data caches/ index caches?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?