how many types transformations supported by sortedinput?
Answer Posted / mansi
Aggregation Transformation supports sortedinput.
So that it will increase the performance.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the types of lookup transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to convert multiple rows to single row (multiple columns) in informatica
How might one distinguish in the case of mapping is right or not without associating session?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the meaning of up gradation of repository?
Differentiate between joiner and lookup transformation?
Clarify the aggregator change?
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?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
draw informatica architecture 8.6 ?
What does role playing dimension mean?
Slowly changing dimensions, types and where will you use them
What are active transformations.