if we hav 10 records in a file, can we get first record from
it by using Aggregator with out using Groupby Port in it?If
Yes..let me know the answer plz!!!
Answer Posted / janardhan
Hi Guys, I need sql query for the above functionality.
I mean sql query to get last record from 10 records same like aggregator transformation in informatica which gives last record if we don't give any group by.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain sql transformation in script mode examples in informatica
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is xml source qualifier transformation in informatica?
What are the transformations that are not supported in mapplet?
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 will be the approach?
What is the sequence generator transformation in informatica?
What are the types of lookup transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the use of code page?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the function of union transformation?
What does “tail –f” command do and what is its use as an Informatica admin.