i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2. what is the procedure and whar t/r's are involved
and what is the mapping flow
Answers were Sorted based on User's Feedback
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....
| Is This Answer Correct ? | 27 Yes | 4 No |
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.
| Is This Answer Correct ? | 6 Yes | 0 No |
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
| Is This Answer Correct ? | 4 Yes | 1 No |
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
| Is This Answer Correct ? | 4 Yes | 4 No |
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
What is the session task and command task?
What is session task and command task?
what is lookupoverriding?
can u give example for factless fact table
how do u tune queries?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
Router T/R is active but some people are saying it is also passive which is exactly right?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query