Answer Posted / amedela chandra sekhar
Union it support only same metadata in both the tables.
it will execute same metadata.
it means reject the unmatched data.
so reject some records.
so it changes the no of records
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
What are the static cache and dynamic cache in informatica?
Why sorter is an active transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain the features of connected and unconnected lookup.
What do you mean by filter transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the use of an aggregator cache file?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is workflow manager?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Parameter and variable differences
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is update strategy transform?
What is Session and Batches?