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
Briefly describe lookup transformation?
What are the popular informatica products?
What is the use of transformation?
What does command task mean?
Can informatica load heterogeneous targets from heterogeneous sources?
What is Data Caches size?
Write the advantages of partitioning a session?
What is the difference between informatics 7x and 8x and what is latest version?
Briefly define reusable transformation?
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 ?
What are ETL Tools?
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
How are indexes created after completing the load process?
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
Explain sessions?