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.
- 5 Answers
- 16343 Views
- I also Faced
- E-Mail Answers
Answer Posted / k.rameshyadav
Lookup T/R is always is an alternate for joiner.
If the sources are same i.e homogenous we can perform join at database level.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain different types of partitioning?
what is pmrep command?
State the differences between shortcut and reusable transformation
How to increase performance without changing anything in mapping.( In prod)
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
What is etl process. How many steps etl contains explain with example?
how do u extract data from different data sources explain with an example?
What are the various tools used in etl?
What are the three tiers in etl?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
tell me few points when u become TL
list and discuss two approaches for updation of target table in Informatica and how they are different.
what is granularity in Data ware House?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
