How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1025

---

Runtime behavior of Normalize and Reformat

2627

---

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

946

---

Difference between output_index and output_indexes in reformat

1230

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

869

---

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

770

---

Intern stastical programmer written test

682

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

725

---

Tell me about MD5 functions in informatica

877

---

Tell me about Propagate functions in informatica

878

---

How to update a particular record in target with out running whole workflow?

1535

---

How you prepared reports for OLAP?

1547

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1795

---

how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

2065

---

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1945

---