Answer / srini

SQ>>EXP>>>TAR

Generate seq in exp and check for condition like

iif(seq<100,10,iif(seq>100 and seq<=200,20,iif(seq>200 and seq<=300,30,40)))

Answer / rocky!!

Here is another answer.
--> SEQ1
SD --> SQ --> EXP --> EXP --> TGT
--> SEQ2

1) Add SEQ1. Keep Starting value as 1 with cycle attribute set in after end value 100.
2) Add Another SEQ2. This is to keep a tab on the record count on the incoming data flow.
3) Get NEXTVAL & NEXTVAL1 from SEQ1 and SEQ2 and dump it in EXP.
4) in EXP, add Varibale port "V_OUTPUT_DECISION" and write code "CEIL(NEXTVAL1/100)"
5) in EXP, add variable "V_BATCH_NO" and initialise value as 10.
6) in EXP, add output port "OUTPUT_DECISION_BATCH_NO" and write code as "V_OUTPUT_DECISION*V_BATCH_NO"
7) connect fields viz, YEAR, DESC, MONTH, SALARY and BATCHNO to Target.

I guess this is the generic code. Bring any number records, should work.

Cheers!!

Answer / santosh

Please follow the below step.

1.Create sequence geneteor which will start with 1.
2.Connect the nextval port to expression t/p.
3.connect port from sq transformation to expression t/p.
4.Create below port in the expression transformation.
a. NEXTVAL_OUT(Variable port)= NEXTVAL-1
b.rec_con(Variable port)= IIF(NEXTVAL_OUT % 100 = 0, REC_CON+10,REC_CON)
c. REC_CON_OUT(Out put port)= rec_con

5. If you have primary key on the target table then use update startegy t/r to update the targer.
6. If you don't have primary key on the target table then use update voerride in the properties tab of the target.
7. U can use the below query to update the target by update override.
UPDATE EMP_UPDATE SET REC_COUNT = :TU.REC_COUNT WHERE EMPID = :TU.EMPID

Please correct me if anything wrong.

Thanks and Regards
Santosh Kumar Sarangi

Answer / srikanth

target update over ride..

Answer / nitin

Source->SQ->Sequence->Exp->Target

In Sequence Generator:
Give Start Value = 1
End value = 100
Check the Properties as CYCLE.

Give the following condition In Expression Transformation:\
O_SEQUENCE= NEXT_VAL
COUNT = IIF(O_SEQUENCE > 1 AND O_SEQUENCE <= 100, COUNT+10)

Make the default value of COUNT as 0

Answer / rajkumar

it's just like a simple pass.But we have to use an
expresion in between source and target we have to continue
the loop of variable port has to continue for every 100
records.

What is the session task and command task?

0 Answers  

Enlist some properties of sessions.

0 Answers  

What are the informatica performance improvement tips

0 Answers   Informatica,

Where do we use mapping variables in informatica?

0 Answers  

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

What is meant by target load plan?

0 Answers  

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

15 Answers   Deloitte,

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,

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

major difference between normal loading and bulk loading?

6 Answers