how to load only the first and last record of a flat file
into the target?
Answers were Sorted based on User's Feedback
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 |
Answer / ysr
using Aggregator trans FIRST and LAST funtions we can pass
first and last record
Is This Answer Correct ? | 21 Yes | 9 No |
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 |
Answer / etl guru
not possible first & last function in aggregator
Is This Answer Correct ? | 11 Yes | 1 No |
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 |
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 |
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 |
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What is CDC? How to implement CDC?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
Explain the features of connected and unconnected lookup.
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
What are the new features of the server manager in the informatica 5.0?
In informatics server which files are created during the session rums?
What are the data movement modes in informatica?
Define filter transformation?
why do u use shortcuts in informatica.?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.