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
- 8376 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
can be used COM component in Informatica ?
What do you understand by active and passive transformations?
What is tracing level?
what is data modeling?
how do u set partition points in the mapping?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Explain the use lookup tables and Aggregate tables?
when will use SQL override in a lookup transformation?
What is initial load and what is full load?
Explain me ETL project architecture in Detail?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
When do we analyze the tables? How do we do it?
SCD2 will work on only dimension tables as well as fact Table?
What are the three tiers in etl?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
