What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
Suppose we do not group by on any ports of the aggregator what will be the output?
how to load only the first and last record of a flat file into the target?
What is meant by a domain?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
difference between stop and abort
i 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
what is difference between mapping and mapplet ?
What is A cache?
without dynamic lookup how to insert new rows and update existing rows?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
without update strategy how to insert &update?