explain abt union t/r?
A union transformation is a multiple input group
transformation,which is used to merge the data from multiple
sources similar to UNION All SQL statements to combine the
results from 2 or more sql statements.
Similar to UNION All statement, the union transformation
doesn't remove duplicate rows.
It is an active transformation.
| Is This Answer Correct ? | 5 Yes | 1 No |
What is metadata reporter?
What is a parameter When and where do you them when does the value will be created
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
what is meant by data driven.. in which scenario we use that..?
What is the function of aggregator transformation?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u