Answer Posted / chandu
Hello All,
I have a query to all of u guys...
U all said If any t/r changes the number of records it is a
active ritee....?
So here my query is about Union t/r, In Informatica by
default Union t/r acts as Union all means allow duplicates..
If I have 2 sources having 20 records each after union t/r
the result should be 40 records so, there is no change in
records, even then it is an active t/r yyyyyyyy?
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a stored procedure transformation?
How might you approve all mappings in the archive all the while?
What is target designer and target load order?
How can you differentiate between powercenter and power map?
What are the restrictions of union transformation?
What is rank transform?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is sq transformation?
Briefly define reusable transformation?
According to his methodology what all you need before you build a datawarehouse
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?
What are the advantages of using informatica as an etl tool over teradata?
What is meant by active and passive transformation?
wf dont have integration severances how you can run?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks