Interested to Buy Any Domain ? << Click Here >> for more details...
how many types transformations supported by sortedinput?
- 4 Answers
- 8252 Views
- I also Faced
- E-Mail Answers
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
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the types of presistent cache in look up tr.
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Is it possible to revert a global repository to local one and why?
What is dynamic cache?
What is a joiner transformation and why it is an active one?
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?
What is informatica metadata and where is it stored?
What is the difference between router and filter?
What is different between the data warehouse and data mart?
How are indexes created after completing the load process?
How do you load first and last records into target table?
