Answer / abdul

can we use GET_DATE_PART Function?

Answer / abhinaw prakash

We can use Date Conversion function to find out the Year and
use SUBSTR function to extract that particular year.

Answer / ram

use TO_DECIMAL(TO_CHAR(COLUM,'YYYY'))

Answer / ganesh reddy

use expression t/r in exp write to_char(hiredate,'yyyy')

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,

---

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  

---

What is meant by active and passive transformation?

0 Answers  

---

What is the command used to run a batch?

0 Answers  

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

---

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: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

---

How to load relational source into file target?

3 Answers   IBM,

---

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---