how to load only the first and last record of a flat file
into the target?
Answer Posted / ghouse
we can write the shell script for it
head -1
tail -1
we call it either in command task or pre and post session
shell commands in seession
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What all join we can perform in LOOKUP transformation?
What is meant by LDAP users?
What do you mean by enterprise data warehousing?
Why do we need informatica?
How can we handle two sessions in informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is joiner change?
How an expression transformation differs from aggregator transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What the difference is between a database, a data warehouse and a data mart?
What is a node in Informatica?
What is meant by a domain?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?