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
- 7634 Views
- I also Faced
- E-Mail Answers
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 |
How do you load unique records into one target table and duplicate records into a different target table?
How will you check the bottle necks in informatica? From where do you start checking?
what is diff between IN and EXIT commands
To provide support for Mainframes source data,which files r used as a COBOL files
Where are the source flat files kept before running the session?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How identifying bottlenecks in various components of informatica and resolving them?
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
how to delete duplicate records by using filter transfermation?
source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?
What is source qualifier transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Teradata 
