Interested to Buy Any Domain ? << Click Here >> for more details...
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!!!
- 8 Answers
- 29719 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jhilam roy
Sorry guys...correction...If you do not select any group by
port in an Aggregator transformation and also want the first
record of any input record set, then, simply use the FIRST
function with no group by ports selected. Because, if there
is no group by ports selected, by default, FIRST treats all
rows as one group, returning one value. However, make sure
that the first record is not NULL. If a value is NULL, FIRST
ignores the row.
| Is This Answer Correct ? | 26 Yes | 2 No |
Post New Answer View All Answers
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
update strategy transformation in informatica
What is the difference between source qualifier transformations source filter to filter transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain what transformation and how many are there in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the types of lookup transformation?
COM components can be used in Informatica
Explain the pipeline partition with real time example?
Mention some types of transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a repository manager?
Define update strategy?
