Answer / usha

By using Sequence Generator transformation.

in Sequence Generator transformation we shoud set

start value =1
cycle should enable
end value = 3
increment value=1

in router we should give condion as
next value=1 for 1st group
next value=2 for 2nd group
next value=3 for 3rd group


S-->SQ--> seq-->rout--> Target1
Target2--> Target3

Answer / sanjay

Sq-->Expression-->Router-->Target
| |
| v
v grp1--> col=1
mod(col,3) grp2--> col=2
Default

Answer / kns

source--->source qualifier-->sequence gen(we want to
reset)--->expression(decode)---->router(conditions)--->targets

Answer / cool buddy

take the rank T/R(take no.of ranks=4)and the take router t/r
in that give conditions as 1)rankindex=1,2)rkindx=2 etc.,


i think this will do .

Answer / sushma

Source ---> SQ ---> Expression ---> Router ---> Targets

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

How do you take back up of repository?

0 Answers  

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

What are session parameters ? How do you set them?

0 Answers  

What is the function of aggregator transformation?

0 Answers  

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

can any one explain me about junk dimension

4 Answers  

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

How to load time dimension?

1 Answers   Ford,