Answer / venkateshmalneni

we can also do it like this
FIRST PIPELINE

From sq connect all the ports to expression t/r and by using sequence generator t/r generate sequence number.
From expression t/r connect the all the ports to the filter t/r write a condition sno=1.
from filter t/r connect all the ports to the target
SECOND PIPELINE

From sq connect all the ports to Aggrigator t/r and dont group by any port,connect the ports to the target
THE DATA FLOW DIAGRAM WILL BE LIKE THIS
sequencegenerator
|
\|/
src--->sq--->expression--->filter--->trg
|
|-->aggrigator--->tgr


I think this will work

Answer / chandrasekar

Please try the SQL query in the SQL override,

select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);


if it wrong means please mail to me chandranmca2007@gmail.com

Answer / rakesh

Hi Chandrasekar,

My intension was to specify the column that is generated using sequence generator as RANK PORT. So no matter of sorting..

Thanks.

Answer / chandrasekar

Hi Rakesh,

Please go through the above question because don't sort the
records what have the source as it is to load the records
for first and last.

Answer / srinivas bolusupati

Use sequence generator t/r and give the nextval link
to 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..

Answer / rakesh

use 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..

Have you worked with/created Parameter file

0 Answers  

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?

3 Answers   TCS,

ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz

1 Answers   IBM,

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

How do you convert single row from source into three rows into target?

0 Answers  

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,