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

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

---

What is flashback table ? Advance thanks

0 Answers   Puma,

---

how to insert header after each group.

1 Answers   IBM,

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

---

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

---

How many dimensions are there in informatica?

0 Answers  

---

what is the size of ur database(like oracle)

2 Answers   HP,

---