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

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

What is source qualifier transformation?

1 Answers  

---

replace multiple spaces with single space.

3 Answers   IBM,

---

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,

---

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---

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

2 Answers  

---

what is service oriented architecture in Informatica 8 version

1 Answers   Cap Gemini, IBM, Systech, TCS,

---

How to update records in Target, without using Update Strategy?

3 Answers  

---

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

---

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

---

What is the use of source qualifier?

0 Answers  

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---