How can i send first half of the records to one target and
Remaining to other target?
Answers were Sorted based on User's Feedback
Here
SOURCE------>SQ--->AGG---> SEQ\ /T1
----->JOINER----->ROUTER----
SOURCE------>SQ--->EXP---> \T2
THIS IS THE PROCESS
HERE AGG--->TWO PORTS 1)NEW PORT 2)COUNT PURPOSE
EXP---->1)NEW PORT ONLY
JOINER-->COMPARE TO THE (AGG & EXP) NEW PORTS AND
APPLY THE FULL JOIN
ROUTER--->TWO CONDITIONS
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mukunda
we have to follow the follwing pipe line
seq--|
SOURCE-->SQ-->EXP-->STOREPROCEDURE-->EXP--->ROUTER---->T1
|------>T2
Using store procedure we can count the total no of rows.
Using sequence genater we have to create the assign the
value to each row. Then find the max rowid using the srore
Procedure t/r. Then this result value store as 'n'. And
the wrire the conditon in router tranformation.
GROUP1--->N<=N/2--->connected to Target1
GROUP2--->N>=N+1/2--->Connected to Target2
*FOR exaple the source table is containg 99 records.
Using the store procedure we can find the count value n as
99.
Conditoin1-->N<=N/2(=44)44 records store in to target1.
Condition2--->N>=N+1/2(=45)-->45 Records store in to the
target2.
If you have any quires plese ask. mukunda.velluri@gmail.com
Is This Answer Correct ? | 8 Yes | 6 No |
Answer / abhinaw prakash
Ypu can write this query in the SQL override.
select * from table_name where rownum < (select
max(rownum)/2) from employees).
Also you can write the same logic in Router and develop a
mapping.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / masudul
Create a two flow mapping.
First Flow-
1.take the original source
2.inside Source qualifier write down the query
select * from (select * from tabl_name) where rownum <=(select count(key_column_name) from tabl_name)/2 );
then dump it to the target. this will take the first half of the entire source.
and in second Flow do the reverse thing..
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / triveni
first pipeline copy nextval port to expression
create one dummy outputport assign 1
second pipeline
deptno decimal 20
totalrecord decimal 10 0 count(deptno)
create another dummy port
dummy decimal 10 0 assign 1
joiner tr common port from 2 pipelines dummy
empno,dummy(detail),totalrecord,dummy1(master)
condition:dummy1=dummy
jointype:normal
router:
nextval<totalrecord/2
nextval>totalrecord/2
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / venu
s----sq------srt----rtr---t1
t2
inthis flow take two sequence generaters and connect to
s0rter t/f like this
nextvalue descending order enable
nextvalue1 asending order enable
for example if 6 records contain
the sort result would be
nextvalue nextvalue1
6 1
5 2
4 3
3 4
2 5
1 6
sorter contain these ports and remaing ports next pass these
ports to ruter t/f
nextvalue > nextvalue1 1st condition ---it give 1st 3rows
nextvalue < nextvalue1 2nd cond ---- it gives last 3 rows
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sakthi
i think we can write sql query in first source qualfier and and select another source qualifier and write sql over ride query
1)select * from employees where rownum <= ( select count(*)/2 from employees);
2)select * from employees minus (select * from employees where rownum <= ( select count(*)/2 from employees));
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sudhakar
Take router tranformation,and creat two groups in that,in
first group write the condition-50<=100 and send
one target,2nd group write the
condition-1<=50 and send it to another target
Is This Answer Correct ? | 1 Yes | 16 No |
Answer / balaji.r
Pass the first half of records to one source qualifier from
that pass to one target,pass the second half of records to
one more source qualifier and pass it to targets
Is This Answer Correct ? | 1 Yes | 20 No |
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?
daily how much amount of data send to production?
How to generate the HTML output using Informatica.
what is the difference between lookupoveride and joiner?
what is row level and column level indicator?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
My source table having some records ,i want load 1st record and last record into one target?
Suppose we do not group by on any ports of the aggregator what will be the output?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
what is index?how it can work in informatica