how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
2 7551Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
7 14359I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
TCS,
6 12917What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
10 32679wht is full process of Information source to target just like stg to productuon and development
1 6323i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
7 23221Post New Informatica Questions
What are the different versions of informatica?
What are ETL Tools?
What is a node in Informatica?
What is an aggregator transformation?
Write the program through which the records can be updated?
How many dimensions are there in informatica?
What's the layout of parameter file (what does a parameter file contain?)?
Write the unconnected lookup syntax and how to return more than one column.
Enlist the differences between database and data warehouse.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to generate sequence numbers?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?