How to load only the first and last record of a flat file into
the target?
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 |
in static and dynamic which one is better
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
how can we run workflow with pmcmd?
In session log thier should not be a single error how will u do
How to import oracle sequence into Informatica?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
what is shortcut in informatica? difference between shortcut,reusable object?
what is data driven?
how to calculate the optimum cache size in aggregator transformation?
What is the procedure for creating independent data marts from informatica 7.1?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd