Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.
5 9094Post New VAMA Informatica Interview Questions
-
VAMA Informatica Interview Questions (1)
What will happen in case you have not issued the command: ‘set hive.enforce.bucketing=true;’ before bucketing a table in hive in apache hive 0.x or 1.x?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
What do you understand by @autowired annotation?
Explain about run unit currency?
what is the use of dsmfmt and dsmserv format?
Define tcp/ip?
What are the extracts and schedules in Tableau server?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
What are the two options for entering plan data? : co- cost center accounting
Explain about asset master?
Why we are doing post heating in alloy steel welding?
When you create an invoice can you carry out pricing again?
How do you print the grid in adobe photoshop?
Explain about mod_vhost_alias?
In how many formats is a report available in excel?
