Answer / prasad

The function appears like this IIF(IS_DATE(DATE, 'DD-MON-YY'),TRUE,FALSE)

Answer / gyana

u can use the TODATE() function to make it as default date
and time

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

0 Answers  

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

What is polling in informatica ?

1 Answers   TCS,

---

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

---

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

---

which one is better performance wise joiner or look up

0 Answers   Informatica,

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---

How to join three sources using joiner?

0 Answers  

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

---

What are differences between Informatica 7.1 and 6.1

3 Answers  

---