Interested to Buy Any Domain ? << Click Here >> for more details...
at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it
- 5 Answers
- 11470 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / madhu tallapaneni
Use COPY , MODIFY, Transformer
Coming to performance point of use Modify or Copy stage instead of transformer stage while dealing with huge volume of data.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
How do you import and export the datastage jobs?
why do u need the IOS upgradation in a FC switch
Enlist various types of routines in datastage.
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How many types of stage?
Which algorithm you used for your hashfile?
How to reverse the string using unix?
root tree will find which is server job and which is parallel job?
What is the difference between account and directory options ?
Differentiate between datastage and informatica?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is data partitioning?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Difference between server jobs & parallel jobs?
