Interested to Buy Any Domain ? << Click Here >> for more details...
Can we combine a flatfile and a database table using an
UNION transformation?
- 2 Answers
- 12835 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 |
Why do we need informatica?
what is session override?
how to design mapping half of source table records into one target and remaining half into another target
Parameter and variable differences
What is difference between stored procedure transformation and external procedure transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
Differnce between filter and router?
what are the transformations that restricts the partitioning of sessions?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
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 the meaning of up gradation of repository?
Teradata 
