Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / swetha
BY using Pivot stage convert rows into columns in
datastage.If we want to change in informatica we use
normalizer transformation.
| Is This Answer Correct ? | 11 Yes | 6 No |
Post New Answer View All Answers
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Define project in datastage?
To see hidden files in LINIX?
On which interface you will be working as a developer?
Notification Activity
Different ways a project can be moved to production ?...example ….export-import and Version control.
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are constraints and derivations?
Enlist various types of routines in datastage.
what is use of SDR function?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How do you schedule or monitoring the job?
