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.

Answer / ysr

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

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

Answer / etl guru

not possible first & last function in aggregator

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/

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

Answer / dl

we will get the result with answer # 4

Answer / tilak

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

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,

what is junk dimension

4 Answers   Cap Gemini,

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

Mention a few design and development best practices for informatica?

0 Answers  

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

what are cost based and rule based approaches and what is the difference?

1 Answers  

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

what are presession,postsession success and postsession failure commands ?

1 Answers  

How can we integrate different flat file data in a single mapping and with in a single execution

1 Answers