How will you display 10-15 letters from a name? (for ex:
name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
Answer Posted / bala
substr(col_name,10,5)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are active and passive transformations?
What is workflow? What are the components of the workflow manager?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is a difference between complete, stop and abort?
What is the difference between informatics 7x and 8x and what is latest version?
How do you load unique records into one target table and duplicate records into a different target table?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
In which transformation you cannot drag ports into it?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Explain scd type 3 through mapping.
What is Cognos script editor?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How many dimensions are there in informatica?