I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
Answer Posted / rajesh
Use head and tail command(Pre session command) write it into two files.Use transformation to read that files as per your requirement
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we create two repositories on same database instance in oracle?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what is diff b/t sorter t/r and agg have the option sorter property...
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a grid in Informatica?
Why update strategy and union transformations are active?
What is the difference between router and filter?
What are connected or unconnected transformations?
How identifying bottlenecks in various components of informatica and resolving them?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Is there any way to read the ms excel datas directly into informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is rank index in rank transformation?
What is source qualifier transformation in informatica?