Interested to Buy Any Domain ? << Click Here >> for more details...
how can we load first and last record from a flat file
source to target?
- 7 Answers
- 29385 Views
- Infosys, ITC Infotech, I also Faced
- E-Mail Answers
Answer Posted / vinod saini
After sql Trans use AGG,JOINER transformation,and use FIRST
& LAST function in AGG transformation without any group.
FIRST & LAST return the first & Last record values. give
JOINER condition based on first & last.
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What is the scenario which compels informatica server to reject files?
design of staging area?
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?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Differences between connected and unconnected lookup?
what is unit testing?tell me proceedure
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What the difference is between a database, a data warehouse and a data mart?
Why filter transformation is an active one?
What is rank index in rank transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the different types of olap? Give an example?
What are data-driven sessions?
What are the different options available for update strategy?
What all join we can perform in LOOKUP transformation?
