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
- 7183 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kasi reddy
using lookup T/R we can join the two tables and using
source qualifier t/r we can join the table
| Is This Answer Correct ? | 3 Yes | 1 No |
we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??
explain the methodology of Data Warehousing?(Polaries)
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain do we need an etl tool?
what is granularity in Data ware House?
What is a lookup table in etl?
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?
What is the difference between round-robin partitioning and hash partitioning?
Which transformation we use to convert 'NA' to 'Not Available'
what are the session parameters? How do u set them?
What is the main difference between peek stage and copy stage
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Teradata 
