Answer Posted / srikanth

Hi,

Both teja and Babu Answers are correct..

But here we need to consider Performance wise which one is
better.

here we have only two flat files one is having 100 million
records and second one having 10 million records.

union transformation can supports for flat files also and it
is acting as union all(don't worry about this).

first drag the 100 million records source and then drag the
10 million records source on mapping designer.
connect these two sources to union transformation.
union transformation can merge the Data By COLUMN by COLUMN.
so it is trying to merge only 10 million records with
existing 100 million records

Then we can tune the performance here.

if we have lot of flat files(same structure) then we have to
go for file indirect.

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

1130

---

What is the use of code page?

1096

---

How to implement security measures using repository manager?

1179

---

Explain what are the different versions of informatica?

1099

---

How can we handle two sessions in informatica?

1033

---

What is a standalone command task?

1206

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2381

---

State the differences between sql override and lookup override?

1209

---

What are the different lookup cache(s)?

1118

---

is it possible to index the data in cache of lkp transformation ?

2029

---

What is substr in informatica?

1209

---

How to create the source and target database connections in server manager?

1090

---

How to use pmcmd utility command?

1034

---

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

1059

---

Can we get 1st record through Informatica(without sequence number).

1479

---