In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
How can we use mapping variables in informatica?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
Under which circumstances, informatica server creates reject files?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
What is deployemnt groups, Lables, query and dynamic deployment group.
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
what is diff between IN and EXIT commands
What is aggregate cache in aggregator transformation?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
Explain pmcmd command usage in informatica