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
How to elaborate tracing level?
write a query to retrieve the latest records from the table sorted by version(scd)
What is informatica etl tool?
Could you explain what is enterprise data warehouse?
Explain lookup transformation source types in informatica
Differentiate between a database and data warehouse?
What do you understand by SOA of Informatica?
What are the types of presistent cache in look up tr.
What is repository manager?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How we can create indexes after completing the loan process?
How do you load only null records into target? Explain through mapping flow.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is a joiner transformation?