how many types transformations supported by sortedinput?
Answers were Sorted based on User's Feedback
Answer / mansi
Aggregator Tranformation,Joiner Tranformation and Lookup
Tranformation support sorted input.
So that it will increase the session performance.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / mansi
Aggregation Transformation supports sortedinput.
So that it will increase the performance.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prasanth
aggrigator,joiner and lookup only three transformations are
supported
| Is This Answer Correct ? | 1 Yes | 0 No |
Which is costliest transformation? costly means occupying more memory?
Can we call a stored procedure from a unix script which is run using command task
what is the method of error handling when session is running?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is Collect performance data in informatica and what is the use of it.
how we can add header and footer to flat files?
2 Answers Tech Mahindra, Zensar,
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
In session log thier should not be a single error how will u do
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
What is mapplet and a reusable transformation?
What is a taget load order?
How are parameters defined in informatica?