we have 1 source table containing 100 records. now we have
to transfer first set of 1-10 (i.e1-10) records to one
target table and another set of 1-10(11-20) records to
other target table and continue like that till 100th record
- 3 Answers
- 8150 Views
- I also Faced
- E-Mail Answers
Answer Posted / swetha
we can use sequence generator with cycle for that
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
how do u really know that paging to disk is happening while u are using a lookup transform?
what are the concerns of OLTP and DSS systems?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
what is pmrep command?
how does the server recongnise the source and target databases.Elaborate on this
how do u extract data from different data sources explain with an example?
What is tracing level?
What do you understand by the term ‘transformation’?
how do use session mapping parameters ?(in which transformation)
what are the types in error loging?
Is apache nifi an etl tool?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What is lookup table in etl testing?
What is data cleaning?
where we cannot use sorter Transformation. if we use then we will not get correct data?
