how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 29020 Views
- CTS, I also Faced
- E-Mail Answers
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 |
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
What is standalone command task?
What are the different types of olap? Give an example?
How i can upload the MainFrame source For Informatica ?
What are the new features of informatica 9.x in developer level?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
In update strategy target table or flat file which gives more performance ? why?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
Different sorts of metadata that stores in the storage facility?
Teradata 
