Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
L&T,
18 30539Suppose 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 9106In 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.........?
4 5388Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
1584i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
4 9057i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
2 4883Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
2 5999Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
2 19948i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
5 7260Post New Informatica Questions
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is aggregator transformation in informatica?
What is the difference between a connected look up and unconnected lookup?
Enlist the advantages of informatica.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How would you copy the content of one repository to another repository?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How do you convert single row from source into three rows into target?
What is a mapplet/worklet in informatica?
Differentiate between source qualifier and filter transformation?
In development project what is the process to follow for an etl developer from day1
4 yrs etl devloper roles and responsibilities?any body give solutions
What is data movement mode in Informatica and difference between them?
How we can create indexes after completing the load process?
What is a standalone command task?