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
- 24978 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between informatica 7.0 and 8.0?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the scenario which compels informatica server to reject files?
Explain the etl program with few examples.
What are the tasks that can be performed using sq?
What is a passive transformation?
Define filter transformation?
I have a flat file, want to reverse the contents of the flat file
How to create or import flat file definition in to the warehouse designer?
What is a joiner transformation and why it is an active one?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is meant by pre and post session shell command?
what are the deliverables?in your project?
