My source table having some records ,i want load 1st record
and last record into one target?

Answers were Sorted based on User's Feedback



My source table having some records ,i want load 1st record and last record into one target?..

Answer / guest

BY USING FIRST FUNCTION, TO GET THE 1ST RECORD,
TO GET THE LAST RECORD , SIMPLY USE AGGREGATE
TRANSFORAMATION IN THIS DO NOT APPLY GROUP BY FUNCTION BY
DEFALUT IT WILL GENERATE LAST RECORD
OR
USE RANK TRANS
IN =>PROPERTIES NO OF TOP RANKS:1
NO OF BOTTOM RANKS:LAST RECORD

Is This Answer Correct ?    13 Yes 0 No

My source table having some records ,i want load 1st record and last record into one target?..

Answer / chandrasekar

I took the EMP table and we can use the below query in the
SQL override,

select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);

it will work.

Is This Answer Correct ?    7 Yes 0 No

My source table having some records ,i want load 1st record and last record into one target?..

Answer / kiran

take two rank transformations and take reusable sequence
generator connect the next value to both rank transformations
and in the rank transformations properties for the first one
take top and number of ranks as 1 for the second take bottom
and number of ranks 1 at the last take two instances of tgt
connect the ranktrans to two instances

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

State the differences between sql override and lookup override?

0 Answers  


What is main use of mapplet?

0 Answers  


How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,


How to recover the standalone session?

2 Answers  


In session log thier should not be a single error how will u do

3 Answers   HCL,


if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  


i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,


i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,


What is event and what are the tasks related to it?

0 Answers  


have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,


in oracle write query yourname+1 from dual

5 Answers  


Categories