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
- 4306 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 |
how do u decide whether u need to do aggregations at database level or at Informatica level?
what are the data modeling tools you have used?(polaris)
What is ROWID explain ?
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 are the parts of Informatica server ?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is meant by drill through?(Mascot)
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
how do u extract data from different data sources explain with an example?
Explain and compare etl & manual development?
Compare etl & elt?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
Teradata 
