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

what is the complex transformation you used in informatica

0 Answers   TCS,

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

scenario

1 Answers  

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

Why you use repository connectivity?

3 Answers   Yash Technologies,

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

What is the benefit of session partitioning?

0 Answers  

server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,