both the file and table metadata should same then we can join

Can we combine a flatfile and a database table using an
UNION transformation?

Question Posted / kunkala ramakrishna

Answer Posted / kunkala ramakrishna

Is This Answer Correct ?

15 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is update strategy transform?

1159

What are the different clients of powercenter?

1114

what is $$$$?

2202

What are the limitations of joiner transformation?

1176

What do you mean by channel change?

1105

without table how to come first record only in oracle?

2301

How to handle decimal places while importing a flatfile into informatica?

1240

What is joiner transformation?

1065

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

1112

What is data transformation manager process?

1220

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1381

What is resilience time?

1224

what is the size of your data warehousing?

2141

where to store informatica rejected data?

1139

What is powercenter on grid?

1227