Answer / vidhyakarthik

SQ - Exp - Target

In exp transformation

newport1 - SUBSTR(column1,1,3)
newport2 - LTRIM(RTRIM(column1))
newport3 - REPLACECHR(1,newport2,'101','')
newport4 - newport1 || ' ' || newport3

pass newport4 to target

anyone pls confirm if it is wrong

Answer / dilip ingole

using SQL

SELECT SUBSTR('101 a 101 b 101 c',1,4) ID ,REPLACE(TRANSLATE('101 a 101 b 101 c','1234567890',' '),' ','') DATA FROM DUAL;

Answer / mahesh

using Aggregator ......

create group by on col1

How we can create indexes after completing the loan process?

0 Answers  

---

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

---

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

---

---

Briefly describe lookup transformation?

0 Answers  

---

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

---

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

---

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---