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
- 8436 Views
- I also Faced
- E-Mail Answers
Answer Posted / balaganesh
Using Sequence Generator and router we can achive this
problem.
In Seq Gen:
1) Set current value is 1 and end value is 3. Also, enable
the recycle option.
Now using router you can separate the records into target.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How many types of transformations supported by sorted input?
What are the modules in Power Mart?
Define slowly changing dimensions (SCD)?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Difference between flat files and relational sources?
What is a mapping?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Can there be sub steps of etl steps?
how do u set partition points in the mapping?
What is tracing level and what are the types?
Explain the difference between etl tool and olap tools?
how would u estimate the size of Aggregator transform data and index cache?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
Is apache nifi an etl tool?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
