how to load only the first and last record of a flat file into the target?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

how to load only the first and last record of a flat file
into the target?

Question Posted / bsgsr

8 Answers
30281 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to load only the first and last record of a flat file into the target?..

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.

Is This Answer Correct ?

14 Yes

2 No

how to load only the first and last record of a flat file into the target?..

Answer / ysr

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

Is This Answer Correct ?

21 Yes

9 No

how to load only the first and last record of a flat file into the target?..

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

Is This Answer Correct ?

12 Yes

2 No

how to load only the first and last record of a flat file into the target?..

Answer / etl guru

not possible first & last function in aggregator

Is This Answer Correct ?

11 Yes

1 No

how to load only the first and last record of a flat file into the target?..

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/

Is This Answer Correct ?

5 Yes

0 No

how to load only the first and last record of a flat file into the target?..

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

Is This Answer Correct ?

0 Yes

1 No

how to load only the first and last record of a flat file into the target?..

Answer / dl

we will get the result with answer # 4

Is This Answer Correct ?

1 Yes

4 No

how to load only the first and last record of a flat file into the target?..

Answer / tilak

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

Is This Answer Correct ?

4 Yes

8 No

Post New Answer