Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / krishraj
It is simple logic, UNION fectches the commmon records
between two tables and it emliminated un-common records. So
it will be Active transformation which means it will change
the number of records.
Any other answers please....
| Is This Answer Correct ? | 1 Yes | 38 No |
Post New Answer View All Answers
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
In development project what is the process to follow for an etl developer from day1
What are the main features of Oracle 8i with context to datawarehouse?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Parameter and variable differences
Explain the different dimensions.
Explain lookup transformation in informatica
Explain the shared cache and re-cache?
list out all the transformations which use cache?
Describe the impact of several join conditions and join order in a joiner transformation?
What is fact table? Explain the different kinds of facts.
How is union transformation utilized?
Explain the scenario which compels informatica server to reject files?
What are the new features of informatica 9.x at the developer level?
Can you use flat files in Mapplets.
