Answer / aakansha

In expression write following if target field is defined
with DATE datatype:
TO_DATE(TO_CHAR(SYSDATE,'DD/MM/YYYY'))

If target field defined with character datatype then use:
TO_CHAR(SYSDATE,'DD/MM/YYYY')

Answer / prabhas

In expression transformation create one out put port, and
write like: TO_DATE('SYSDATE'.'DD/MM/YYYY').
Connect this port to target.

Answer / ramana

we need two pipelines in mapping.In first pipeline,take expression trans,create one port with date type and assign sysdate to it.After drag this port to target file.
In the second pipeline load the source record into target file.But here we need to select APPEND IF EXISTS option.Both pipelines we need to give same file name.

8.what is mapplet ?give example?

2 Answers  

---

difference between stop and abort

2 Answers  

---

can every transfomation reusable?how?

2 Answers   Wipro,

---

What are the different options available for update strategy?

0 Answers  

---

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

---

How we can use union transformation?

0 Answers  

---

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

---

What are the session parameters?

3 Answers  

---

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

---

What are the uses of etl tools?

0 Answers  

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

how can we use sorter transformation in joins?

5 Answers   IBM,

---