how to load only the first and last record of a flat file
into the target?
Post New Answer View All Answers
Differentiate between sessions and batches?
Explain what are the different types of transformation available in informatica.
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the advantages of informatica?
What is target load order?
As union transformation gives UNION ALL output, how you will get the UNION output?
How to generate sequence numbers without using the sequence generator transformation?
What is workflow monitor?
How does the aggregator transformation handle null values?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How can we update a record in the target table without using update strategy?
Why filter transformation is an active one?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Describe expression transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .