I have 10 columns in a flat file and 10 rows corresponding to that columns.
I want column number 5 and 6 for last five records.
In unix as well as informtica.
Mapplets can you use an active transformation in a mapplet,
how do u fnd the duplicate rows and how to delete the duplicate rows?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
Explain the mapping variable usage example in informatica
In ur current projectu have done any performance tuning of mappings?
what is constraint based loading
Why filter transformation is an active one?
From where we can start or use pmcmd?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
How can we update a record in the target table without using update strategy?
What does “tail –f” command do and what is its use as an Informatica admin.
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000