Interested to Buy Any Domain ? << Click Here >> for more details...
why union is active transformation?
- 4 Answers
- 8348 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shobhan
if input number of rows are not equal to output number of rows, that would be Active transformation. In Union Transformation, input will more and output will be less. SO, this is a Active Transformation.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / amedela chandra sekhar
Union it support only same metadata in both the tables.
it will execute same metadata.
it means reject the unmatched data.
so reject some records.
so it changes the no of records
| Is This Answer Correct ? | 2 Yes | 7 No |
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
Explain in detail about scd type 1 through mapping.
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
Explain the tuning lookup transformation - informatica
What is aggregate cache in aggregator transforamtion?
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
What is the procedure for creating independent data marts from informatica 7.1?
What is the role of informatica in project ?Like i showed financial projects?
what is incremental data aggregation?
What are the performance considerations when working with aggregator transformation?
In a table, 4 person having same salary. How to get Third person record only?
Can we combine a flatfile and a database table using an UNION transformation?
Teradata 
