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 different threads in DTM process?

2 Answers  

---

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

---

Please let me know how to make Data masking in informatica..

0 Answers  

---

What is informatica worklet?

0 Answers  

---

What all join we can perform in LOOKUP transformation?

0 Answers  

---

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

---

How can we use mapping variables in informatica?

0 Answers  

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---

How the facts will be loaded? explain

2 Answers   HCL,

---