my name is amar i want display 1st line A 2nd line M 3rd line
A 4th line R in database & informatica
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 |
what is the main role of FI on business
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.
Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?
What is factless fact schema?
how many maximum session supports to multiload in teradata ??
what happens if the info.server doesn't find the session parameter in the parameter file?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
what is the meaning of upgradation of Repository?
what is meant by drill through?(Mascot)
Explain and compare etl & manual development?