It will work without making sequence generator cyclic select mod(floor(3

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.

Question Posted / santosh_dw

7 Answers
15094 Views
Cognizant, Wipro, I also Faced
E-Mail Answers

Answer Posted / santosh_dw

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which version configuration tool used in ur project?

3198

list out all the transformations which use cache?

1131

what are the deliverables?in your project?

2102

Explain the different lookup methods used in informatica?

988

How we can create indexes after completing the load process?

1127

What are active transformations.

1609

How can we use mapping variables in informatica? Where do we use them?

1124

What is workflow monitor?

1013

What is meant by active and passive transformation?

1062

What does reusable transformation mean?

1087

what is degenerated dimension?

3899

Explain pushdown optimization and types in informatica

1034

Describe an informatica powercenter?

1057

What is a difference between complete, stop and abort?

1046

Different circumstance which drives informatica server to expel records?

935