How to generate sequence numbers using expression transformation?
How to load duplicate records in to a target table which has a primary key?
What is intricate mapping?
What are the new features of informatica 7.1?
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
What is the need of etl tools?
what is datamart
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
After we make a folder shared can it be reversed?Why?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
What is an unconnected transformation?
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
What do you understand by SOA of Informatica?