What is a filter transformation and why it is an active one?
No Answer is Posted For this Question
Be the First to Post Answer
How can i set break points in debugging mode ? can explain steps please?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use
explan ur project architecture?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
What are 2 modes of data movement in Informatica Server?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Can you copy the session to a different folder or repository?
Tell me about Propagate functions in informatica
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.
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3