Answer / rayudu

$$$SessStartTime is a string type data type and
SessStartTime is Date?Time Data type.


Regards,
rayudu.

Answer / soundarya

we can use $$$SessStartTime in Mapping or mapplet filter
conditions

User-defined joins

SQL overrides
in designer and workflow manger also

We can use SESSSTARTTIME in Expresion in the designer

what are the deliverables?in your project?

0 Answers   DELL,

---

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  

---

What is status code?

2 Answers  

---

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

---

tell me about your project functionality

0 Answers  

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

---

Why touse stored procedure in ETL Application?

2 Answers  

---

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

1 Answers   TCS,

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---