in sequtial file 2 columns avaliable,iwant only one column
load the target how do it.
Answer Posted / yarramasu
we can use merge stage and drop unwanted columns and we can
also use transformer stage in this stage we have to do
which columns do u want that columns only u can drag from
source to target
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Lookup constraints
sed,awk,head
What are the functionalities of link collector?
How to implement complex jobs in data stage?
Define Routines and their types?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the difference between datastage and informatica?
What is active and passive stage?
Distinguish between informatica & datastage. Which one would you choose and why?
How can we improve the performance in datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is difference between join, merge and lookup stage?
Why fact table is in normal form?
Difference between data warehousing and olap?