Interested to Buy Any Domain ? << Click Here >> for more details...
Hi please try to reply with answer. my mail id is
raghu.1028@gmail.com.
if the source is having millions of records, but having
theree target tables. As per user the first record need to
insert into first target and second record in to a second
target and third into third target, similarly the process
needs to repeat?
- 5 Answers
- 8437 Views
- I also Faced
- E-Mail Answers
Answer Posted / siddiq
First U will create sequence number for the 3records
using sequence generator t/r then U can create an
expression t/r in that use the mod function like
mod(seqno,3)=1
mod(seqno,3)=2
mod(seqno,3)=0
then u will get the resulr
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is fact? What are the types of facts?
what are Lookup caches options? Including persistent caches.
what do u do when DB time takes more?in sap bi
What are the steps involved in etl process?
what are the production issues in datastage?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
What do you understand by the term ‘transformation’?
What is the difference between project backlog and product backlog?
how would u estimate the size of Aggregator transform data and index cache?
what is the main role of FI on business
what are the reporting tools and difference between them?
how to connect to a flatfile through ftp in informatica
what is dynamic insert?
What are the modules in Power Mart?
What are dimensions?
