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 |
what is data driven?
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
what is data driven in update strategy transformation?
What is the difference between Normal load and Bulk load?
In a concurrent batch if a session fails, can you start again from that session
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
What are the types of maping in Getting Started Wizard?
How to load a Dimension ? and how to load a fact table?
What are the main features of Oracle 8i with context to datawarehouse?
why we are using level option in normalizer transformation
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?