without dynamic lookup how to insert new rows and update
existing rows?
How do you migrate data from one environment to another?
What is the need of building a data warehouse?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
What is an active transformation?
What is decode in informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
What are the guidelines to be followed while using union transformation?