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.
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
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Briefly define a session task?
Make a note of the quantity vaults made in informatica?
Mention few advantages of router transformation over filter transformation.
What is the benefit of partitioning a session?
How we can create indexes after completing the load process?
Separate from an archive server and a powerhouse?
What will be the approach?
What could be the possible resons of locks by user?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Different circumstance which drives informatica server to expel records?
What is the maplet?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to implement security measures using repository manager?
What are different types of transformations available in informatica?