How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
No Answer is Posted For this Question
Be the First to Post Answer
Write the unconnected lookup syntax and how to return more than one column.
Differentiate between reusable transformation and mapplet.
What are Dimensional table?
What are ETL Tools?
Explain grouped cross tab?
Can anyone please distinguish what is Inner join and Outer join
What is the difference between STOP and ABORT options in Workflow Monitor?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
Issue with Update override at Target table in Informatica.
Roles and Responsibilties of Informatica Production Support Member?