i have an aggregater in my mapping and no group by port on
any column and i ampassing 100 rows through aggregater,so
how many rows i will get as out put from aggregater
Answers were Sorted based on User's Feedback
Answer / sreenivas
it will return 100th row of the source if group by port is
not selected in aggregator
thanks,
sreenivas
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / pooja
all rows will come, since its not grouped. if its group by,
then last row will be out.
| Is This Answer Correct ? | 3 Yes | 14 No |
Explain about perform recovery?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Can we update the data in flat file using update strategy?
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!!!
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to do Integration testing in Informatica?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
What is a difference between complete, stop and abort?