Answer / radha

We can use Router t/r also.
create as many conditions u want.
say, if rownum=2 then flow the data to target 1
if rownum=5 then flow to another target
go on....

Answer / ssrinivas624

any one heard about cume()function...
Using cume() funtction we can achieve this...
take any expresion after source qualifier add a row_cume
port and write an expression like cume(1)...
take a filter t/r write row_cume = 2 OR row_cume = 5 in
condition tab. Like any number of different rows u can
get...

two targets...
--->FILTER--->TARGET1
SQ--->EXP
--->FILTER--->TARGET2

same target...
SQ--->EXP--->FILTER--->TARGET


in the place of two filters u can go for router also...

Answer / lvpr

Another way is to use rank t/r and load data to target by
filtering 2 and 5 rows.

Answer / lvpr

Use two pipe lines...first pipeline add sequence gen t/r
and send data to dummy target...

In second pipeline take first pipe line's target as source
as we have seq numbers for each row now route 2 and 5 row
to diff target's or to same target

Answer / lokesh

src->sq->seq_gen->exp->flt->targer

in seq_gen property's put cycle 3,

write a condition as a nextlevel=2, insert into target.

Answer / raja

by using router it solve it.it is the best method to insert the data in to each target.

Answer / pavan

using Router transformation we can solve this.
create as many conditions u want.
Suppose,if rownum=2 then flow the data to target 1
if rownum=5 then flow to another target
go on....

Answer / sateesh

Source-->SQ-->SequenceGenerator-->Exp-->Rtr-->Target

In Exp Transformation assign a variable port like v_num=10;

In Rtr Transformation use defined group give a condition
like

IIF(curvar>1,IIF(Mod(v_num,curvar)=0,0,1),1)

Please correct me if am wrong.

Can you start a session inside a batch individually?

2 Answers  

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,

Why touse stored procedure in ETL Application?

2 Answers  

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,

h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,

need for registering a repository server

1 Answers  

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,