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

explain about session partitions ?

1 Answers  

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,

---

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

How will you combine 3 different sources with a single source?

3 Answers  

---

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

---

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  

---

How can we use mapping variables in informatica?

0 Answers  

---

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

---

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

---