-
Relational connection
Hi friends, I connect the pubs database and i move the data to the target successfully. but i connect the Northwind as the same procedure but the task is failed. I don't know what the fault is this? Anyone answer this question please....
-
Surrogate key
Why we implement sarrogate key in ETL Process?
-
Cached Lookup and an Uncached Lookup
What is the difference between using a cached lookup and an uncached lookup?
-
transfer data from xls and ms-access to oracle
how we can transfer data from ms-excel, ms-access to oracle through informatica ? whether it is possible?
-
Informatica Dynamic Source and Target
Similar to creating dynamic target can we create dynamic source?
-
Significant change in Version 8 of informatica
Hi all,I would like to know what are the key differences between PowerCenter 7 vs 8? Give one significant change version 8 is offering?
-
Failed Workflow
When you run the sessions in a sequence what will happen when the first workflow fails and later you want to start with the second one and followed by others. Where will you do changes or necessary steps to run the workflow.
-
Loading data from Datamarts
Which approach is better and why?Loading data from datamarts to datawarehouse or vice versa?
-
-
Eliminate Duplicate Records
HiI am having 10000 records in flat file, in that there are 100 records are duplicate records..soo we want to eliminate those records..which is the best method we have to follow.RegardsMahesh Reddy
-
-
-
-
-
-
-
Why use the lookup transformation ?
To perform the following tasks. Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target table to make your summary data easier to read. Perform a calculation. Many normalized tables include values used in a calculation, such as gross sales per invoice or sales tax, but not the calculated value (such as net sales). Update...
-
How do you identify existing rows of data in the target table using lookup transformation
Can identify existing rows of data using unconnected lookup transformation.