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
- 25017 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 |
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Design a mapping to load a target table with the following values from the above source?
What are the basic needs to join two sources in a source qualifier?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
How to get EVEN & ODD numbers separately?
What is mapplet in informatica?
how do u use sequence created in oracle in informatica? Explain with an simple example
How to implement security measures using repository manager?
How are indexes created after completing the load process?
what are presession,postsession success and postsession failure commands ?
Mention a few design and development best practices for informatica?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
Teradata 
