How to load only the first and last record of a flat file into
the target?
- 3 Answers
- 8541 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
can you use flat file for lookup table?why?
Scheduling properties,whats the default (sequential)
What is mapping debugger?
Which will beter perform IIf or decode?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
why do u use shortcuts in informatica.?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
hw cn v elimate dublicate values from lookup without overriding sql?
What is powercenter on grid?
What is the Difference between PowerPlay transformer and power play reports?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Teradata 
