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
- 25023 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 |
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
how to identify new and old values in source qualifier or any other transformations using informatica
What is session task and command task?
What is the maplet?
What are the data movement modes in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Could any one to tell How to use the Oracle Analytic functions in Informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
difference between stop and abort
What are the join types in joiner transformation?
Teradata 
