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.
Answer Posted / janet
Simple SQL logic in the source qualifier sql will take care
of this issue.
Select product_id, month, sum(sales)
from source_table
group by product_id, month;
Then you can just pass the values straight through. No
need to split, aggregate, and join, etc.
Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
Explain the aggregator transformation?
What is difference between a gateway node and worker node?
How might one distinguish in the case of mapping is right or not without associating session?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Differentiate between source qualifier and filter transformation?
What does cheating measurement mean?
what is song in infrmatica...?
How can you define user defied event?
Explain sessions. Explain how batches are used to combine executions?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is a repository? And how to add it in an informatica client?
Can you generate sequence numbers without using the sequence generator transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Separate from a database, an information bazaar, and an information stockroom?
How many input parameters can exist in an unconnected lookup?