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 |
Explain the flow of data in Iinformatica?
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
Difference between task flow and linear task flow
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Partition, what happens if the specified key range is shorter and longer
what is meant by data driven.. in which scenario we use that..?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
Explain in detail scd type 2 through mapping.
Explain dynamic target flat file name generation in informatica