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 |
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
what is target load plan
What are the connected or unconnected transforamations?
What is log file,and where is it located,why u r using the log file
What is union transformation in informatica?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
What are the different types of code pages available in informatica & how to implement it in your project?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
What is source qualifier transformation in informatica?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
how the informatica server sorts the strings values in rank transformations?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?