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

What is the target load order?

3 Answers   HCL, Informatica,

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

performance tuning of Informatica

1 Answers  

what is distinct

4 Answers  

can you use flat file for lookup table?why?

2 Answers   HCL,

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?

2 Answers   Ness Technologies,

can u any challenge your project?

0 Answers   HP,

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

What is data transformation manager process?

0 Answers  

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers