Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ravi
hi all please post relevant answers the question is why
union transformation is active transformation
not the properties of union transformation
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is an Integration service in Informatica?
Can you generate sequence numbers without using the sequence generator transformation?
Performance tuning( what you did in performance tuning)
explain abt ur project architecture?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to differentiate between the active and passive transformations?
Enlist few areas or real-time situations where informatica is required.
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain lookup transformation in informatica
How we can create indexes after completing the loan process?
Describe data concatenation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How do you load unique records into one target table and duplicate records into a different target table?
