Can we combine a flatfile and a database table using an
UNION transformation?
Answers were Sorted based on User's Feedback
both the file and table metadata should same then we can join
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / surya
You can connect heterogeneous sources to a Union transformation.The transformation merges sources with matching ports and outputs the data from one output group with the same ports as the input groups
Is This Answer Correct ? | 4 Yes | 2 No |
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
What is olap (on-line analytical processing?
expain about the tune parameters?
Explain informatica architecture - version 8 / 9
Explain joiner transformation in informatica
How many repositories can we create in Informatica?
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
What is the filename which you need to configure in UNIX while installing infromatica?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
Differentiate between sessions and batches?
How to generate sequence numbers without using the sequence generator transformation?