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 in informatica
have u done any performance tuning? how u ll do?
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
how remove 1st 3 records & last 3 records in informatics
What is the Process to creating lookup transformation in informatica
Difference between task flow and linear task flow
Explain why we use partitioning the session in informatica?
What is different between informatica version 8 and 9 version
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
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
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this