How to load only the first and last record of a flat file into the target?

How to load only the first and last record of a flat file into
the target?

Question Posted / balu

3 Answers
9806 Views
Mind Tree, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to load only the first and last record of a flat file into the target?..

Answer / yaseen

After SQ place 2 Rank T/R and a reusable sequence generator T/R having start value 1. In 1st Rank give the top 1 and in 2nd Rank set bottom 1

Is This Answer Correct ?

7 Yes

2 No

How to load only the first and last record of a flat file into the target?..

Answer / spandita

After SQ expre/aggregate without selecting group by option
then it displays default last record for displaying first
record there is first function enable this then it displays
1st record.....

Is This Answer Correct ?

3 Yes

0 No

How to load only the first and last record of a flat file into the target?..

Answer / harish konda

First connect the exp1 with source and Sequence t/f's.

And next take the sorter and sort the data in descending
order of NEXTVAL port.

And again connect sorter to exp2 and connect sequence t/f to
this exp2.

And then connect this exp2 to router and give these
conditions NEXTVAL=1(of first sequence) and NEXTVAL=2(of
second sequence) then rout to the target.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

All active transformations r passive or not?

7 Answers

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers HCL, Thomson Reuters,

Write the different tools in the workflow manager?

0 Answers

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers L&T,

What are 2 modes of data movement in Informatica Server?

1 Answers Informatica,

define galaxy repository in informatica

0 Answers

How does the session recovery work.

1 Answers

Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers

what is bridge tables in informatica

1 Answers CTS,

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers CTS,

For more Informatica Interview Questions Click Here