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
- 24961 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 |
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
What is A complex mapping?
In any project how many mappings they will use(minimum)?
What is facttable granularity?
how to create user defined function (udf) in informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
What is union transformation in informatica?
How to handle changing source file counts in a mapping?
What is the difference Between Mapping parameter and variable
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
How to call shell scripts from informatica?
Teradata 
