Answer / vani

Can it be done in this way....

1)Drag source to mapping designer
2)Take a router transformation .consider EMP table in which
i am using EMPNO. In group1, assign the condition as
mod(empno,2)=0 which gives even numbers and in group2,
assign the condition as mod(empno,2)!=0 which gives odd numbers.
3)connect group1 to one target and group2 to another target.

If i am wrong please tell me....

Answer / sree

1. drag source and targets in to mapping designer work space
2. from t/r devoloper take sequence genarato t/r,exp t/r
and router t/r.
3. in seqg t/r give startvalue 1 ,increment by 1
give netval to a newpor in exp t/r
4. drag all ports of sq to exp in addition to newport
5. in router t/r create one group name as odd
give condetion mode(newport/2)!=0
6. give from group odd to t1
and defoult to t2.

Answer / anand kumar

We can do this in the following.

Take the sequence generator t/r
set the properties like
Start value 1
End value 2
and also Enable cycle option

connect the nextval port to the router T/r
port "SGTNO"(created by you) and also connect the ports
from source qualifier to the router t/r

Now given the first condition like
SGTNO=1 then go to first target
otherwise go to second target(here no need to mention the
second condition).

If I went wrong, please let me know

Thanks
Anand Kumar

Answer / sreekar

Hi,

Steps:-

1.Load ur source table into source analyzer.

2.generate the target tables.

3.in the maping designer take 2 filter transformations and
write these queries in each of the filter transformations

for even no of records:- select * from <tablename> where
(rowid,1) in (select rowid, mod(rownum,2) from <tablename>)

for odd no of records:- select * from <tablename> where
(rowid,0) in (select rowid, mod(rownum,2) from <tablename>)\

4. connect the output ports of this transformation to their
respective output tables.

Note:-
send your responses to suriaslesha_sreekar@yahoo.co.in

in which situations do u go for scds ?

3 Answers   TCS,

---

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,

---

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

---

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

---

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,

---

Where are the source flat files kept before running the session?

0 Answers   Informatica,

---

how can we run workflow with pmcmd?

3 Answers   Wipro,

---

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

What is the use of incremental aggregation?

2 Answers  

---