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
- 12734 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 |
How do you promote a non-reusable transformation to reusable transformation?
How can we delete duplicate rows from flat files?
how can one come to know wether the records loak into the target if we use update strategy
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
What are the tuning techniques you applied during your last project
What are two types of processes that informatica runs the session?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
Explain constraint based loading in informatica
What are the types of metadata that stores in repository?
What are Dimensions and various types of Dimensions?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
Teradata 
