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
- 30901 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 |
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
What is event and what are the tasks related to it?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
what is informatica metadata?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
What are the prerequisite tasks to achieve the session partition?
what is the use of Java Transformation in Informatica 8.x?
How to call shell scripts from informatica?
How to get EVEN & ODD numbers separately?
Teradata 
