How to load last 10 records of flat file in to the target?
- 5 Answers
- 23144 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 |
why do u use shortcuts in informatica.?
can we override a native sql query within informatica? Where do we do it? How do we do it?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
What is junk dimention?
What are the reusable transforamtions?
What aer the out put files that the informatica server creates during the session running?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
What is the need for an etl tool?
When we are using Dynamic Cache,which options we will select in session level?
What are Rapid changing dimensions?
What is the difference between unicode & ascii mode data movement in informatica?
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
Teradata 
