How can i send first half of the records to one target and Remaining to other ta

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

How can i send first half of the records to one target and
Remaining to other target?

Question Posted / ramana110

10 Answers
29283 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can i send first half of the records to one target and Remaining to other target?..

Answer / gvk

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

How can i send first half of the records to one target and Remaining to other target?..

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

How can i send first half of the records to one target and Remaining to other target?..

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

How can i send first half of the records to one target and Remaining to other target?..

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

How can i send first half of the records to one target and Remaining to other target?..

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

How can i send first half of the records to one target and Remaining to other target?..

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

How can i send first half of the records to one target and Remaining to other target?..

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

How can i send first half of the records to one target and Remaining to other target?..

Answer / mukesh

use router t/r

Is This Answer Correct ?

5 Yes

5 No

How can i send first half of the records to one target and Remaining to other target?..

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

How can i send first half of the records to one target and Remaining to other target?..

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

Post New Answer