You Can create dummy port for each source Qual. then connect to Join Trans

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no
common column)
output should contain merged data(8 columns)
Please let me know how to achieve ??

Question Posted / moorthy g

3 Answers
7824 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / moorthy g

You Can create dummy port for each source Qual. then connect
to Join Trans., and Join two dummy port.in Joiner
Transformation.

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the mapping variable usage example in informatica

1224

What is the Rank index port in Rank transformation?

1102

Write the unconnected lookup syntax and how to return more than one column.

1147

How to generate sequence numbers?

1131

Informatica settings are available in which file?

1040

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1555

Do you find any difficulty while working with flat files as source and target?

1146

Clarify the aggregator change?

1077

Why update strategy and union transformations are active? Explain with examples.

1284

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

1130

In which transformation you cannot drag ports into it?

1377

What are the different types of repositories created using informatica?

1168

What is data movement mode in Informatica and difference between them?

1181

Can anyone tell me the new features in Informatica 9 Version?

2206

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1227