Can we combine a flatfile and a database table using an
UNION transformation?
- 2 Answers
- 11846 Views
- Accenture, I also Faced
- E-Mail Answers
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 are the components of the workflow manager?
Which gives the more performance when compare to fixed width and delimited file ? and why?
Plz can any one say me how to get the informatica certification materials and dumps
what is the difference between static and dynamic
how many types transformations supported by sortedinput?
What is the difference between Power Centre and Power Mart?
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
what is lookup chache?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
What do you mean by channel change?
Teradata 
