Interested to Buy Any Domain ? << Click Here >> for more details...
how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 30581 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 |
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?
what is the difference between static and dynamic
without dynamic lookup transformation how to insert new rows and update existing rows?
tell me 7.x and 8.x diferrencess(but not transformations)
what are types of dimentions?
What is the need of etl tools?
How to extract original records at one target & Duplicate records at one target?
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
Explain how many types of dimensions are available in informatica?
What are the types of schemas we have in data warehouse.
In dimension and fact table? which one holds big data?
Teradata 
