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

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

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.

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..

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

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

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));

Answer / mukesh

use router t/r

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

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

What are the connected or unconnected transforamations?

2 Answers  

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

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

10 Answers   TCS,

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

Describe data concatenation?

0 Answers  

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg

0 Answers  

How many input parameters can exist in an unconnected lookup?

0 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,