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 status code?

2 Answers  

---

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

---

What is a sorter transformation?

0 Answers   Informatica,

---

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

---

What is informatica metadata and where is it stored?

0 Answers  

---

Explain reference cursor?

1 Answers  

---

What is log file,and where is it located,why u r using the log file

1 Answers   TCS,

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

How do you do error handling in Informatica?

1 Answers  

---