Answer / manthiramoorthy. g

SQ-->EXP-SEQ-RTR-TARGETS

Router
=======
Make 3 Groups
MOD(NEXTVAL,3) = 0
MOD(NEXTVAL,3) = 1
MOD(NEXTVAL,3) = 2

Answer / mayur

SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target

Answer / chandra

SQ--->EXP-->ROUTER---->TARs


In EXP take 2 output ports ,In one output port write
mod(id,3)=1and second Oport write mod(id,3)=2..,
Next drag the ports to ROUTER
In router take 2 groups ,IN first group write condition
mod(id,1)=1
and second group write condition mod(id,3)=2
finaly drag 3output groups into 3targets

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

---

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

---

What is the Hierarchy of DWH?

1 Answers  

---

Define Incremental Aggregation?

2 Answers  

---

What does cheating measurement mean?

0 Answers  

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

in static and dynamic which one is better

2 Answers  

---

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

0 Answers   Puma,

---

Have you worked with/created Parameter file

0 Answers  

---