I am having two tables,say table1 having cols
Empid,firstname,lastname,middlename and table2 having
Empid,firstname,lastname can i union them using Union t/f?
Answer Posted / ganithi anil
for union t/f tables structures should be same, i mean
columns and data types should besame then only you use
union t/f
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Is there any target staging area in informatica not staging area
Parameter and variable differences
Tell me about MD5 functions in informatica
Define filter transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the different types of repositories created using informatica?
How many numbers of sessions can one group in batches?
What is lookup transformation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
explain about unit testing? in real time?
How is union transformation utilized?
How many transformations can be used in mapplets.
What is enterprise data warehousing?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?