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

Answer Posted / kunkala ramakrishna

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

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we update a record in the target table without using update strategy?

885


What is a router transformation?

823


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

830


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

812


How can we use mapping variables in informatica? Where do we use them?

825


Explain the types of transformations?

788


What is the advantage of informatica?

821


How to do unit testing in informatica?

931


How an expression transformation differs from aggregator transformation?

818


generate date / time dimension in informatica

882


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4495


Define filter transformation?

854


Explain the code page compatibility?

827


how to load dimension table and fact table. plz tell me the steps.

1860


Can you generate sequence numbers without using the sequence generator transformation?

809