how can we use sorter transformation in joins?
Answer Posted / rakesh
while using the option sorted input, we must have to use sorter t/r before joiner to send the sorted data to the joiner.
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Define enterprise data warehousing?
Can we create multiple integration service on single repository?
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?
As union transformation gives UNION ALL output, how you will get the UNION output?
How might one distinguish in the case of mapping is right or not without associating session?
Explain incremental aggregation in informatica
Scheduling properties,whats the default (sequential)
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 are the settings that you use to configure the joiner transformation?
Define joiner transformation?
What is flashback table ? Advance thanks
What is the difference between writing a joiner query in ANSI style and THETA style?
Tell me about Propagate functions in informatica
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Enlist the tasks for which source qualifier transformation is used.