In my source i have 10 records but i want 11 records in target. How can i ache

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

Question Posted / rajesh.s

2 Answers
7785 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / huma

That's a stupid question!!

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Data Stage Interview Questions

whats relation between configuration file and datasets?

2 Answers L&T, Wipro,

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers Deloitte, IBM,

HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers ME,

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers IBM,

What is the roundrobin collector?

0 Answers

when we will use connected Lookup & Unconnected Lookup

3 Answers Wipro,

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers Accenture,

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers

parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?

3 Answers

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers Hexaware,

I have a few records just I want to store each records tow times in target how?

2 Answers Polaris,

For more Data Stage Interview Questions Click Here