Interested to Buy Any Domain ? << Click Here >> for more details...
my name is amar i want display 1st line A 2nd line M 3rd line
A 4th line R in database & informatica
- 1 Answers
- 4344 Views
- HCL, I also Faced
- E-Mail Answers
Answer / lajpat kurdiya
SELECT SUBSTR('AMAR',LEVEL,1) AS Name
FROM DUAL
CONNECT BY LEVEL<= LENGTH('AMAR');
| Is This Answer Correct ? | 4 Yes | 0 No |
where is the cache (lookup, index) created and how can you see it.
how to connect to a flatfile through ftp in informatica
what is the difference between cubes and package in cognos
what are variable ports and list two situations when they can be used?
List few etl bugs?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
what is pmrep command?
CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
In Which Transformation We Can Use Having Clause In Informatica?
Teradata 
