Answer / srinu

I have an IDEA,
After sql Trans,go with AGG,RANK transformation,
in RankTrans Properties set the rank 1 only---1 row returns,
In AggTrans Dont do any column for Group--Last row returns,
We need 2 Target tables. 1 for 1st record,2 for last record,
if u using the UNIONtrans one Target table is enough,,,
i think it wii help u,,,,,,srinu,,,,,,,,,

Answer / hardeep

We can use below configurations to achieve desired output. We need 1 SQ, 1 SGen, 2 Rank and 2 Trgt Defn(same Trt). I think it will be cheaper.

Src-SQualifier-->
|
Rank1(Top 1st) -->Trgt1
--->
Rank2(Bottom 1st) -->Trgt2
|
SGen(NEXTVAL)-->

Answer / hina

Below transformation would work: Add the Nextval port of the sequence generator to both the Rank Transformations. In rank transformation select Top and Bottom resp.
------ Rank Transformation (Top)----Tgt(Ins1)
|
SQ---Sequence Generator-----
|
-------Rank Transformation(Bottom)-Tgt(Ins2)

Answer / vinod saini

After sql Trans use AGG,JOINER transformation,and use FIRST
& LAST function in AGG transformation without any group.
FIRST & LAST return the first & Last record values. give
JOINER condition based on first & last.

Answer / srinu

Hi,,, Vinod, As per your Solution we have to check
complete data Table for ,,

syntax for 1st,last:::

FIRST( ITEM_NAME, ITEM_PRICE > 40 )

FLOOR( PRICE )

ok,,,
Any corrections Let me Know,,,
srinu.srinuvas@gmail.com

Answer / sudhar

Alternatively we can use the unix pre session command to
read the 1st and last record from the file and place it in
another file and use that new file as source to load the
target table.

Answer / dharmendra

SRC QF -> SEQ -> EXP -> AGR -> RTR -> TGT
create a port in expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
th record.create 2 condition in in router one with SEQ = 1
and another with SEQ = count of rows (this will give last
row).connect both to target.dont forget to give reset
option in SEQ generator.

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  

in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

what are challenges that you faced in testing? give solution to it?

1 Answers  

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

What is joiner transformation in informatica?

0 Answers  

Is informatica power center designer has 64 bit support?

1 Answers  

What is A complex mapping?

3 Answers   TCS,

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,