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

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

Explain what is informatica metadata and where is it stored?

0 Answers  

---

How to do the error handling of if ur source is flatfiles?

0 Answers  

---

Two Default User groups created in the repository are ____ and ______

2 Answers  

---

---

What is an active transformation?

0 Answers   Informatica,

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

Make a note of the quantity vaults made in informatica?

0 Answers  

---

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---