Can we combine a flatfile and a database table using an
UNION transformation?
Answer Posted / 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 |
Post New Answer View All Answers
what is SDLC way of code development?
What are the advantages of informatica?
Where do we use mapping variables in informatica?
What is joiner transformation in informatica?
explain one complex mapping with logic? sales project?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How big was your fact table
Mention few power centre client applications with their basic purpose?
What are the data movement modes in informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the settings that you use to configure the joiner transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to load last n records of file into target table - informatica
Explain pushdown optimization $pushdownconfig parameter - informatica