Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two tables without using joiner transformation
.advantages of joiner over lookup and vice versa.
- 2 Answers
- 7109 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
we can join two table by using source qualifier t/r
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / swathi
using source qualifier and also lookup transformation,
joiner lookup
--------------------------------------------
active t/r passive t/r
supports horizontal merging supports horizontal merging
supports only equi join both equi& non equi join
| Is This Answer Correct ? | 4 Yes | 1 No |
What do you understand by the term ‘transformation’?
What is etl tool in hadoop?
what are the parts of Informatica server ?
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
Explain about hash partitioning?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
how do u automate Extraction process?
how do u extract data from different data sources explain with an example?
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is the difference steps for data modeling?
Teradata 
