I have 2 Files like
fileA fileB Output1 Output2 Output3
1 6 1 6 11
2 7 2 7 12
3 8 3 8 13
4 9 4 9 14
5 10 5 10 15
6 11
7 12
8 13
9 14
10 15

please let know

Answer Posted / vinod upputuri

You are right chetan, but in the second lookup we have to
use seq file 1 for main link and o/p2 is linked as reference.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the use of surogate key in datastage

1812


Explain datastage architecture?

811


Could anyone give brief explanation bout datastage admin

1965


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1633


What is quality stage?

566






Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1663


Highlight the main features of datastage?

613


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

766


How do you reject records in a transformer?

624


What are the enhancements made in datastage 7.5 compare with 7.0?

705


Where the datastage stored his repository?

613


What are the types of containers and how to create them?

556


1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3497


What are the job parameters?

701


What is the purpose of interprocessor stage in server jobs?

1724