Answer Posted / eswar

As Prakash said
ower write sq ("select *from <tableNmae> where rownum <=
10;")

Instead of using Aggregator its better if we use Router
Transformation, wherefrom we can route the rows to target
(s).

note: use two target table in which u want to load that two
records
====

How do you update the records with or without using update strategy?

1164

---

How to use procedural logic inside infromatica?

1323

---

Please let me know how to make Data masking in informatica..

1775

---

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

4252

---

What are pre and post-session shell commands?

1389

---

difference between informatica 8.1.1 and 8.6

3732

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2087

---

How to convert multiple rows to single row (multiple columns) in informatica

1429

---

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

1173

---

Briefly describe lookup transformation?

1097

---

What are roles and groups and benefits of using them?

1104

---

Explain the shared cache and re-cache?

1165

---

Can informatica load heterogeneous targets from heterogeneous sources?

1235

---

How to do unit testing in informatica? How to load data in informatica ?

1187

---

What is the difference between stop and abort in informatica

1144

---