Interested to Buy Any Domain ? << Click Here >> for more details...
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
L&T,
18 35605Suppose 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 10591In 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 6918Please 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
2031i 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 10870i 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 5800Can 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 7144Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
2 21236i 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 9025Post New Informatica Questions
How to create a non-reusable instance of reusable transformations?
What are the restrictions of union transformation?
explain one complex mapping with logic? sales project?
Describe the impact of several join conditions and join order in a joiner transformation?
Explain lookup transformation source types in informatica
What are session parameters ? How do you set them?
what is informatica metadata?
How can we handle two sessions in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is lookup transformation?
Design a mapping to load a target table with the following values from the above source?
How will the document be delivered to me?
Which means the first record should come as last record and last record should come as first record and load into the target file?
To import the flat file definition into the designer where should the flat file be placed?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
