Interested to Buy Any Domain ? << Click Here >> for more details...
How to load last 10 records of flat file in to the target?
- 5 Answers
- 25194 Views
- iNautix, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amedela chandra sekhar
By using UNIX command tail command .
it display last N lines file.By default it display last 10
lines.
$tail file name
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / koti
sequence generator, rank transformation.. in rank
transformation write the condition 20 ranks, bottom to top..
| Is This Answer Correct ? | 11 Yes | 5 No |
Answer / kalpesh radadia
SQ---- Exp ---- Sorter----Exp --- Filter---Sorter ---
Target.
Connect the source qualifier transfromation to an
expression transformation. In the expression
transformation, create the below ports:
v_cnt (variable port) = v_cnt+1
o_cnt (output_port) = v_cnt
Connect the expression transformation to the sorter
transformation. Sort the rows on the o_cnt port in
descending order.
Now connect the sorter transformation to the expression
transformation (do not connect o_cnt port).
Again Connect to expression transformation create the ports
mentioned above
v_cnt (variable port) = v_cnt+1 o_cnt
(output_port) = v_cnt
Connect to a filter transformation and specify the filter
condition as o_cnt<=N
Connect the expression transformation to the sorter
transformation. Sort the rows on the o_cnt port in
descending order.
Connec to the target
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prathima
by using filter t/r after sourcequalifier t/r there we
write the condition.
| Is This Answer Correct ? | 3 Yes | 10 No |
what is the location of parameter file in informatica?
What is a joiner transformation?
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
What differs when we choose the sorted input for aggregator transformation?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
What are the limitations of joiner transformation?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
what is procedure to use mapping variable in source qualifier transformation? with example
how to join the two flatfiles using the joiner t/r if there is no matching port?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
diffrence between command task and control task
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
Teradata 
