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 the command used to run a batch?
What are the data movement modes in informatcia?
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
how you will maintain version?
write a query to retrieve the latest records from the table sorted by version(scd)
tell me the informatica architecture
Explain lookup transformation is active in informatica
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
Performance tuning( what you did in performance tuning)