how can we load first and last record from a flat file
source to target?

Answer Posted / sudhar

Alternatively we can use the unix pre session command to
read the 1st and last record from the file and place it in
another file and use that new file as source to load the
target table.

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly describe lookup transformation?

796


What are the popular informatica products?

811


What is the use of transformation?

775


What does command task mean?

817


Can informatica load heterogeneous targets from heterogeneous sources?

947


What is Data Caches size?

839


Write the advantages of partitioning a session?

1000


What is the difference between informatics 7x and 8x and what is latest version?

803


Briefly define reusable transformation?

852


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2136


What are ETL Tools?

856


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2097


How are indexes created after completing the load process?

1243


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1669


Explain sessions?

779