Answer / ganesh kumar

SELECT SUBSTR('INDIA',LEVEL,1) AS INDIA FROM DUAL CONNECT BY
LEVEL<=LENGTH('INDIA');

TRY THIS QUERY IT WILL WORKS CORRECTLY.

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,

---

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

---

need for registering a repository server

1 Answers  

---

Define the various join types of joiner transformation?

0 Answers  

---

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

---

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

---

What are the reusable transformations?

0 Answers   Informatica,

---

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---