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

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

Define the various join types of joiner transformation?

0 Answers  

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

what is mean by complex business rule ?

0 Answers   Cap Gemini,

What is an expression transformation in informatica?

0 Answers  

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

What are Rapid changing dimensions?

1 Answers  

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

explain abt union t/r?

1 Answers   IBM,

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers