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
- 4409 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 |
when should one create lookup transformation ?
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
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.
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
without using ETL tool can u prepare a Data warehousing and maintaining?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what is HISTOGRAM? how to generate statistics?
Teradata 
