how remove 1st 3 records & last 3 records in informatics
Answer Posted / davankumar p
2 pipelines,1st pipeline sorter t/r ascending order then
rank t/r top3
2nd pipeline sorter decending order then rank top3 t/r
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
How can informatica be used for an organization?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is meant by a domain?
Enlist some properties of sessions.
Why union transformation is an active transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Performance tuning( what you did in performance tuning)
difference between repository database and repository service?
Separate from a database, an information bazaar, and an information stockroom?
Explain what transformation and how many are there in informatica?
What are the measure objects?
How many types of sessions are there in informatica.please explain them?
Did u used latest transformations of 8.6.0? for what?
How does the aggregator transformation handle null values?