Answer / venkat

decode is better perform than iff condtion,decode can be
uesd insted of using multiple iff cases

Answer / abhishek guddu

DECODE FUNCTION YOU CAN FIND IN SQL BUT IIF FUNCTION IS NOT
IN SQL. DECODE FUNCTION WILL GIVE CLEAR READABILITY TO
UNDERSTAND THE LOGIC TO OTHER.

Answer / james

Decode function has better performance than IIF function,
bcoz for multiple conditions we have to use nested queries
when u r going with IIF whereas with Decode u don't have to
write nested queries.

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

---

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,

---

What is the use of source qualifier?

0 Answers  

---

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

---

what is the use of Data Mart?

5 Answers   IBM,

---

What is workflow manager?

0 Answers  

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

diffrence between command task and control task

1 Answers   iNautix,

---

what is hash table in informatica?

1 Answers   Zensar,

---

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

---

what type of problem you faced insales project or insurance project

1 Answers   Sony,

---

Issue with Update override at Target table in Informatica.

2 Answers  

---