How will you display 10-15 letters from a name? (for ex:
name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
Answers were Sorted based on User's Feedback
Answer / krishna
by using thie function sbustr(column_name,10,15) in the exp
t/r, u can get the output.
| Is This Answer Correct ? | 21 Yes | 1 No |
Answer / gyana
SUBSTR(COLUMN_NAME,STARTING POSITION(10),NUMBER OF CHARACTER YOU WANT(5));
IT WILL GIVE YOU THE OUT PUT 10TH POSITION TO 15 TH CHARACTER STRING
| Is This Answer Correct ? | 2 Yes | 0 No |
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
what are the transformations that restricts the partitioning of sessions?
When the informatica server marks that a batch is failed?
waht type of interface is used for testing the data in informatica
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
How can we improve session performance in aggregator transformation?
How you count the number of records available at your source?
What is meant by active and passive transformation?
What is surrogate key?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How we will implement Pushdown Optimization and Types in Informatica with better examples