Answer Posted / sharad sharma
The simple ligic of Union is that, It capture all the
unique recorde from bothe the source.
suppose if you have 10 records in table A and 10 records in
table B, in which 3 records are same in both the tables.
Then after using the Union transformation you will get 17
records, as the rescords which are getting duplicated will
not be in the output.
Is This Answer Correct ? | 5 Yes | 47 No |
Post New Answer View All Answers
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the different options available for update strategy?
Explain the different lookup methods used in informatica?
how to load rows into fact table in data warehouse
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Differentiate between Load Manager and DTM?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Tell me about Propagate functions in informatica
What do you mean by filter transformation?
What are the types of caches in lookup?
Scheduling properties,whats the default (sequential)
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is dimensional table?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Parameter and variable differences