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
No Answer is Posted For this Question
Be the First to Post Answer
what is sparse lookup?
source which format u will get either fixed or delimiter length format? what is the symbol of delimiter?
Name the command line functions to import and export the DS jobs?
Have you have ever worked in unix environment and why it is useful in datastage?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
How do you load dimension data and fact data? Which is first
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
Nls stands for what in datastage?
Why fact table is in normal form?
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
how many write modes are there in ds