Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data.
How to recognize zero records in source flat file?I read a flatfile and I should ABORT () if there are no incoming records. How I can do this? The source file is on Unix, so I could use shell scripts, but I would to do this in Informatica....Another questions:can I use Unix pipe as input ("flat")file? A fast method to determine which record I'm processing now? i.e. in the 5th record of the flat file I have to do something special, how to find out this record? ThanksSergej
What is the way to add the total number of records that have been read from SRC in the TGT file as last line?
Let me clear you if my TGT is a flat file and want to add total number of records that are written in TGT as a last line with sysdate.
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 to retrieve only distinct record from 'flatfile' source, without using sorter transformation? Is it posible? How?
HP Interview Question
How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.
Latest Answer : The only way to join two flat file is joiner transformation,if the structure of the two flat file is same and the datatypes also matches we can use union transformation, but it wont join the flat files, it will merge the flat flies. In informatica the ...
How to retrieve only distinct record from 'flatfile' source, without using sorter transformation? Is it posible? How?
Latest Answer : Create a Variable port for all the input port and keep them in a seequence that the variable ports will access first after the input port. Then, compare the same variable ports in the ouput port along with the key columns. If there is any duplicate records ...
