If two flat files are having same structure then we can join by using Unio

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?

Question Posted / amedela chandra sekhar

If two flat files are having same structure then we can join
by using Union transformation.

Chandu

Is This Answer Correct ?

16 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain what transformation and how many are there in informatica?

955

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

1012

What is the difference between a connected look up and unconnected lookup?

966

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1079

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2421

How to improve the performance of a session using sorter transformation?

1146

Explian the Process of deployment groups in informatica

1062

Explain why we use partitioning the session in informatica?

1093

What is the use of an aggregator cache file?

1199

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953

What is domain and gateway node?

1165

Tell me about Propagate functions in informatica

922

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1079

What is the session task and command task?

1059