Interested to Buy Any Domain ? << Click Here >> for more details...
why union transformation is active transformation?
- 6 Answers
- 24234 Views
- IndiGo, TCS, I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
If the source1 has 10 records and the it contains 3 records
and the same 3 records are in the second source,the second
source contains 10 records if we want to join them using union
t/r then the output is 17 records instead of 20 records.
thats why we say that UNION T/R is active t/r
| Is This Answer Correct ? | 3 Yes | 32 No |
Post New Answer View All Answers
Describe the impact of several join conditions and join order in a joiner transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain the different kinds of facts.
Explain the difference between a data warehouse and a data mart?
what is mean by complex business rule ?
Can we create a Integration service without a Repository service and vice versa?
Define update strategy?
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.
Target increases every day even though no new record was inserted
How do you load alternate records into different tables through mapping flow?
can u give example for factless fact table
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the designer tools for creating transformations?
How would you copy the content of one repository to another repository?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
