Interested to Buy Any Domain ? << Click Here >> for more details...
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall?
Please answer below. thank you.
- 4 Answers
- 8600 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / me
If you use sorted input and do not sort data correctly, the session fails.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What are the differences between source qualifier and joiner transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the mapping parameters and mapping variables?
permutations of mapplet
Explain the use of aggregator cache file?
How to open an older version of an object in the workspace?
How do you set a varible in incremental aggregation
What are active transformations.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is meant by active and passive transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Did u used latest transformations of 8.6.0? for what?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the function of look up transformation?
