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)

Answer / prasad

use router t/r for loeading data in mutlipule targets .in
that routr t/r use mod function .

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

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

Answer / shalini

how can we get this output without using Cycle option in sequence Generator.

Answer / 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.

Answer / ahalyabest@gmail.com

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

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3

4 Answers   Bank Of America,

What are the types of maping in Getting Started Wizard?

1 Answers  

How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

Why sorter is an active transformation?

0 Answers   Informatica,

How the facts will be loaded? explain

2 Answers   HCL,

Define joiner transformation?

0 Answers  

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,