Answer / bsgsr

first record can be loaded using the top and only one rank
in ranker transformation.
the last record using aggregator without group by option.

Answer / ysr

using Aggregator trans FIRST and LAST funtions we can pass
first and last record

Answer / ghouse

we can write the shell script for it
head -1
tail -1
we call it either in command task or pre and post session
shell commands in seession

Answer / etl guru

not possible first & last function in aggregator

Answer / ram pothineni

Create a port in Expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
the records. Create 2 condition 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.


http://it.toolbox.com/people/raambabuchowdary/

Answer / sanjay gupta

Hi ysr

Can u define the steps please or can u send mapping on my
email id i.e. sanjayguptaa04@gmail.com?

I tried but i am unable to do it..

Thanx in advance

Answer / dl

we will get the result with answer # 4

Answer / tilak

use sequence generator , pass values only with max and min
sequence number filter to target

How can you differentiate between powercenter and power map?

0 Answers  

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

What is a design?

1 Answers  

What are the performance considerations when working with aggregator transformation?

0 Answers  

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

What is the difference between a table and the materialized view?

2 Answers  

what is work of PUSH DOWN option

2 Answers   Wipro,