In my source i have 10 records but i want 11 records in
target. How can i acheive this in Server jobs.

Answer Posted / satyam

using pivot satage you can get that target records dont bother ok you have to implement that ,otherwise transformer stage in also you can add one record in output colomns and implement thatderivation cell . ok i think it very useful to tour question

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define repository tables in datastage?

699


Which commands are used to import and export the datastage jobs?

978


How a source file is populated?

612


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

363


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1615






Difference between ‘validated ok’ and ‘compiled’ in data stage?

668


What is usage analysis in datastage?

811


What are the some differences between 7.x and 8.x version of datastage?

738


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1745


What are the different type of jobs in datastage?

604


What is the purpose of interprocessor stage in server jobs?

1724


Nls stands for what in datastage?

726


Can you explain link buffering?

724


what is the use of skid in reporting?

1953


Explain connectivity between datastage with datasources?

595