Interested to Buy Any Domain ? << Click Here >> for more details...
I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?
- 2 Answers
- 3790 Views
- Accenture, Saama Tech, TCS, I also Faced
- E-Mail Answers
Answer Posted / bhavemanali10
Joiner Transformation is better in case of heterogeneous join(join 2 tables exist in the different database).
While lookup and SQ is better approach to join two tables which exist in same database
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the key challenges that you face while performing etl testing.
What do you understand by active and passive transformations?
what is the meant by Normalization and de-normalization?
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 partitioning? Explain about round-robin, hash partitioning.
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Two default user groups created in the repository are____and_____.
Compare etl & elt?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
what is data modeling?
What are materialized views & where do we use them?
When do we go for the tools in the market?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
explain the methodology of Data Warehousing?(Polaries)
