Answer Posted / paulo coelho

In an Unix environment, do:

page YourFile | sort | uniq -c

What is a predefined event?

1082

---

Define the various join types of joiner transformation?

981

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2148

---

What are the popular informatica products?

1001

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1616

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1042

---

What are the new features of informatica 9.x in developer level?

974

---

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

1568

---

where to store informatica rejected data? How to extract the informatica rejected data?

985

---

How to do unit testing in informatica?

1161

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4132

---

What does “tail –f” command do and what is its use as an Informatica admin.

1081

---

What is the function of union transformation?

1112

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1040

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1065

---