Answer / venkatesh.malneni

here we want to conform one thing that's is there serial no
or not
if there is serial no then we can just take a router then
create three(3) groups
First group for First target
Second is for second target
Third is for third target
write the condition as fallows
mod(s.no,3)=1-------> first target
mod(s.no,3)=2--------> second target
mod(s.no,3)=0-------->third target
if there is no s.no in source then create s.no by using
sequence generator t/r


the flow will be as fallows
/--------->t1
src--->sq---->router/----------->t2
\------------>t3

or if u use sequence generator the flow will be

sequqncegenerator
| /--------->t1
src--->sq---->router/----------->t2
\------------>t3

Answer / chandra

this can be done in two ways.....
1st one

after the SQ we can take EXP Tr
in EXP take one output port like O_SEQ
before EXP Tr take SGT Tr ...
In SGT properties enable cycling and
set START VAL 1 and END VAL 3
then connect the NEXVAL port into O_SEQ port of EXP Tr
after that take ROUTER Tr
in ROU Tr take 3 groups
1st group put condition as O_SEQ=1
2ns group O_SEQ=2 and
3 rd O_SEQ=3
and then drag the 1 st group data into TRG1
2nd group data into TRG2
and 3rd group data into TRG3

the fllow will be like
SRC--->SQ--->SGT--->EXP--->ROU-->TRG1
---> TRG2
--->TRG3

or
we can use MOD function in EXP Tr we can done this

Answer / ankur saini er.ankur861@gmail.

i think the best way to achieve this is to add a cyclic
sequecn gen which will gen 1,2,3 again 1,2,3 again 1,2,3

addd a router then or 3 filters add dump the the data from
sep filters or router groups to the diff targets as
required..

Thanks...

What are the tasks that source qualifier performs?

1 Answers  

---

What are the prerequisite tasks to achieve the session partition?

0 Answers  

---

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

---

explain abt joiner t/r?

1 Answers   IBM,

---

Explain what are the different types of transformation available in informatica.

0 Answers  

---

What is transformation?

0 Answers  

---

What is mapplet in informatica?

0 Answers  

---

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

---

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

0 Answers   CTS,

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

---

what is session parameters?

1 Answers   Cap Gemini,

---