Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
No Answer is Posted For this Question
Be the First to Post Answer
can anyone explain me about retail domain project in informatica?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
What is a mapplet/worklet in informatica?
Mention few advantages of router transformation over filter transformation.
In how many ways we can create ports?
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
Where do you create/define mapping parameter and mapping variable?
Explain factlessfact table with scenario
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
what is Active lock explain
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
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.