how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
2 8415Hi 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 16382I'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 14592What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?
10 36295wht is full process of Information source to target just like stg to productuon and development
1 6993i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
7 25669Post New Informatica Questions
What is decode in informatica?
What is a dimensional model?
What is informatica etl tool?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What are the different types of olap? Give an example?
generate date / time dimension in informatica
What are the types of schemas we have in data warehouse.
explain abt ur project architecture?
What is transformation?
Global and Local shortcuts. Advantages.
Explain in detail scd type 2 through mapping.
What is sorter transformation?
what is the -ve test case in your project.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Mention few power centre client applications with their basic purpose?