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
Answer Posted / 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 |
Post New Answer View All Answers
How do you convert single row from source into three rows into target?
How do you load only null records into target?
What is workflow manager?
Define update strategy?
What is a dimensional model?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to do unit testing in informatica?
What are roles and groups and benefits of using them?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
difference between repository database and repository service?
How would you join a node to the already existing domain?
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?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is union transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?