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 the commit type if you have a transaction control transformation in the mapping?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
what is the size of u r source(like file or table)?
What is meant by target load plan?
I have a flat file, want to reverse the contents of the flat file
What do you understand by SOA of Informatica?
Why do we need informatica?
Explain sessions?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is a router transformation?
Enlist some properties of sessions.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How can we update a record in the target table without using update strategy?