Interested to Buy Any Domain ? << Click Here >> for more details...
I have a file it contain 2 records like empname,company as
Ram, Tcs and Ram, IBM. But i want empname,
company1,company2 as Ram, TCS,IBM in the target. How?
- 6 Answers
- 13914 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
Venkatesh is Absolutely right but unfinished. After remove
duplicate stage we have to use either column import stage or
transformer stage.
SEQ>>>TRANS>>>REMOVEDUPLICATE>>>COLUMNIMPORT/TRANSFORMER>>>TARGET
if Transformer: use field function in derivation
for company1: field(company,',',1)
company2: filed(company,',',2)
for column import stage: specify the key column: company
default delimeter: ','
columns: company1 and company2
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Differentiate between validated and Compiled in the Datastage?
What are the types of jobs we have in datastage?
Difference between sequential file and data set?
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.
How can you write parallel routines in datastage PX?
Which commands are used to import and export the datastage jobs?
What is a merge?
Why we use surrogate key?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is a datastage job?
On which interface you will be working as a developer?
How do you generate sequence number in datastage?
Define meta stage?
If you want to use a same piece of code in different jobs, how will you achieve this?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
