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.
Answers were Sorted based on User's Feedback
Answer / mukunda
Mapping structure
=================
source-->sq-->sequence-->exp-->router-->target1
|-->target2
1)Pass the seq genarator "nextval" port to expression.
2)through expression t/r pass the variable port to router
3)In router create two groups
Group1:nexval<=50-->this group conneted to target1
Groutp2:nexval>=50-->this group conneted to target2
or
default group connected to target2
Note: This logic only that source data contain 100 records.
If you any quires please ask.
Best Regards,
Mukunda
mukunda.velluri@gmail.com
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
After SQ take expression and add port
v_Sequene=v_Sequence+1
o_Sequence=v_Sequence
Take Router Transformation and add two groups
Group1 = o_sequence<=50
Group2=o_sequence>50
Connect Group1 and Group2 to Target1 and Target2
Is This Answer Correct ? | 0 Yes | 0 No |
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is source qualifier?
write a query to get maximum salary from the employers table without duplicates....kindly help me
how many types transformations supported by sortedinput?
Define mapping and session?
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
what are the output files that the informatica server creats during running a session?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?