Reusable transformation and shortcut differences
No Answer is Posted For this Question
Be the First to Post Answer
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
What is dimensional table?
Under what condition selecting sorted input in aggregator may fail the session?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
Tell me one complex query in oracle ?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
What is the need of etl tools?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
If we set dd_insert in mapping and Delete in session properties what will happen.?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?