Hello Everyone,i have one question on sequence generator.i
have two targets and the records comes from the source will
place in the targets like 1-10 rec in target1 and 11-20 rec
in target2,21-30 rec in target1...etc so any one can help
me? plz..Thanq in adv.
Answers were Sorted based on User's Feedback
Answer / babu
Hi,
Mappimg::
SRC=>SQ=>SEQ GEN=>EXP=>RTR=>TRG1 &TRG2
First we have to take 4 mapping variables,those are
VAR1=1 increment by 20
VAR2=10 increment by 20
VAR3=11 increment by 20
VAR4=20 increment by 20
in RTR two groups are there group 1::
IIF( NEXTVAL>=VAR1 AND NEXTVAL<=VAR2)
GROUP 2 :: IIF( NEXTVAL>=VAR3 AND NEXTVAL<=VAR4)
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / prasad
use router t/r for loeading data in mutlipule targets .in
that routr t/r use mod function .
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / krish
i didnt get ur scenario ur saying that 1-10 11-20 this
should continue.
if this is the thing u need to check the cycle option
increment by 1
end value 20
current value 0
check reset(to be on safe side)
in exp create to o/p ports
like first_10values
second_10values
then take router
in that give first_10VALUES<11;
GIVE THAT CONNECT INTO ONE TARGET
AND THE DEFAULT INTO ANOTHER TARGET.
give the condition
Is This Answer Correct ? | 5 Yes | 4 No |
Answer / santosh kumar sarangi
1.Take a sequence generator and connect it to the expression
t/r.
2.In expression transformation create a out put post and
keep the below condition;
VAL_OUT = iif(mod(floor((nextval-1)/10),2)=0,0,1)
3.Keep a router t/r, and filter with the condition VAL_OUT=0
then first target and if VAL_OUT=1 then second target.
Let me know if any thing wrong.
Thanks & Regads
Santosh Kumar Sarangi
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shalini
how can we get this output without using Cycle option in sequence Generator.
Is This Answer Correct ? | 0 Yes | 0 No |
It will work without making sequence generator cyclic
select mod(floor(3/10),2) from dual;
Ans: 0
select mod(floor(12/10),2) from dual;
Ans: 1
select mod(floor(25/10),2) from dual;
Ans: 0
select mod(floor(35/10),2) from dual;
Ans: 1
Thanks,
Santosh.
Is This Answer Correct ? | 0 Yes | 0 No |
SQ---> SEQ GEN---> EXP--> ROUTER---> TRG1, TRG2, TRG3, TRG4
in seq generator properties
start value-1
increment value-1
end value-4
current value-1
cycle-true
reset-true
in router conditions
4 conditions
group 1= iif ((nextval=1)1,0)
group 2=iif (( nextval=2)1,0)
group 3=iif((nextval=3)1,0)
group 4=iif((nextval=4)1,0)
connect
group1-->target1
group2-->target2
group3-->target3
group4-->target4
Is This Answer Correct ? | 1 Yes | 2 No |
What is a dimensional model?
What is joiner cache?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
In which circumstances that informatica server creates Reject files?
Router T/R is active but some people are saying it is also passive which is exactly right?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
In ur current projectu have done any performance tuning of mappings?
have u done any performance tuning? how u ll do?
While importing the relational source defintion from database,what are the meta data of source U import?
What is different between informatica version 8 and 9 version
What is a surrogate key?Why we use it in a mapping?Pl give an example.