I am using a flat file as source, my question is how can I know the end of file is reached? Is there any possibility to configure in session properties.
How can I use multiple filter transformations? How do I pass dropped rows to next filter transformation to check the conditions?
Latest Answer: || is used to concatinate two or more columns in Informaticafor exp; firstname (venu)last name (adavelly)but expecting out put is venu adavellyso we need to concatinate firstname and last name fristname||' '||last name ( we can give any secial in b/w ...
Why do we need two connections for source? One is designer and another one is workflow manager? What is difference?
I am getting this error "ORA-14050: invalid ALTER INDEX MODIFY PARTITION option" while running a procedure through informatica session. But the same procedure is executed successfully and doing
I have a requirement to convert date format.my requirement is as followsi hav date column in my source.my source data in date columnv_date10-11-200619-aug-199925-dec-05null11-5-05like thismy requirement
Latest Answer: Simple use expression transformation and make all the inputs into the date format given. Add a condition like IIF(ISNULL(V-date),SYSDATE(),IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')This is my idea. It helps you hopefully....thx ...
Latest Answer: $ - These are the system variables like $Bad file,$input file, $output file, $DB connection$$ - user defined variables$$$ - $$$SessStartTime $$$SessStartTime returns the initial system date value on the machine hosting the PowerCenter Server when the ...
Latest Answer: Once you create a shortcut, you can reuse it in the folder as often as necessary. There are two types of short cuts: LOCAL & GLOBAL ...
What is use of UNIX in Informatica? Where and how can we use UNIX shell scripts or commands to run informatica jobs or other related applications in informatica?Please tell in details as i am working on
Latest Answer: HiThese are some ways unix works with Informatica.1) In unix box, we can create a SCRIPT which calls informatica session and make the session run.2) We can UPDATE STATISTICS or CLEANUP files by creating pre defined functions.3) Also, I can call ...
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
