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
- 7276 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
What is cube grouping?
Do we need an etl tool?
What are various etl tools in the market?
Two default user groups created in the repository are____and_____.
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.
what is the use of server?
what is the main role of FI on business
What are the differences between sql override and update override?
Explain the key challenges that you face while performing etl testing.
What are the various tools used in etl?
What is staging area referring to?
how do u implement configuration management in Informatica?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What are your responsibilities as an etl tester?
