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

what is lookupoverriding?

1 Answers  

without using rank transformation how can we rank items by using some other transformations

2 Answers  

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

Explain transaction control transformation in informatica

0 Answers   Informatica,

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

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  

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

how did u understand business requirement?

2 Answers   TCS,

What is the different lookup cache(s)?

0 Answers  

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,