Answer Posted / murugan
by using expression transformation ...we can use this function
init caps...
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x at the developer level?
State the differences between sql override and lookup override?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the difference between Active and Passive transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the difference between source qualifier transformations source filter to filter transformation?
How does the aggregator transformation handle null values?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Quickly characterize reusable change?
What is the need of an ETL tool?
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
What is joiner transformation in informatica?
How to elaborate powercenter integration service?
