Interested to Buy Any Domain ? << Click Here >> for more details...
i have a source with 100 records.i have 2 targets.in the first
target i want to load first 50 records & in the second target
i want to load next 50(or remaining) records.
- 3 Answers
- 7771 Views
- I also Faced
- E-Mail Answers
Answer Posted / balakrushna
Hi Mukunda,
U r correct but, y u are using addional t/r Exp, without
EXP we will make this mapping scenario,
I made it actually, that is the way i am sending this
like as follow
SQ-Gen-|
|
Source--> SQL------>RTR->Target1
|
|--->Target2
In SQ-Gen:
Change the Startvalue, Endvalue and Check the CYCLE and
RESET option in the properties of SQ-Gen
popuklate the NEXTVAL from Seq_gen to RTR.
In the RTR t/r:
(as my scnario the 3 records will load tgt1 and next 3 will
load in tgt2 and next 3 will load in again TGT1 and so on..)
2 groups
one is NEXTVAL <= 3
and NEXTVAL >= 4
and populated these groups to ur target accordingly.
Thanks & Regards
Balakrushna
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain why we use partitioning the session in informatica?
What is the command used to run a batch?
What are the uses of etl tools?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Enlist the differences between database and data warehouse.
How to do unit testing in informatica?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
what is diff b/t sorter t/r and agg have the option sorter property...
Different circumstance which drives informatica server to expel records?
What are the prerequisite tasks to achieve the session partition?
How can you increase the performance in joiner transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain transaction control transformation in informatica
What is domain and gateway node?
What is option by which we can run all the sessions in a batch simultaneously?
