Answer Posted / somnath pain

I suppose u r working with informatica.
So here u can import the source and after the source use a
expression transformation.
use a sq generator set start val to 1.
connect the nextval port to expession transformation.
apply a filter and set filter condition as nextval=1 connect
the filter o/p to target.
u will get the desired row.

regards,
Somnath

Explain pmcmd command usage in informatica

1133

---

How many transformations can be used in mapplets.

1935

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767

---

What is update strategy transform?

1102

---

What is transformation?

1099

---

What is a sequence generator transformation?

1021

---

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

4160

---

Can informatica load heterogeneous targets from heterogeneous sources?

1187

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1032

---

Explain sessions?

1064

---

Explain the types of transformations?

1068

---

Tell me about MD5 functions in informatica

929

---

how to load rows into fact table in data warehouse

1190

---

Informatica settings are available in which file?

990

---

What is the sequence generator transformation in informatica?

1184

---