in sequtial file 2 columns avaliable,iwant only one column
load the target how do it.
Answer Posted / ritesh kumar chatterjee
Use Copy Stage and drag and drop the required columns @target
Very Easy way :)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you implement SCD2 using join, transformer and funnel stage?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How to RD using transformer?
What is the difference between datastage and datastage tx?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Differentiate between odbc and drs stage?
What is merge stage?
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.
What is the importance of the exception activity in datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How do you register plug-ins?
How to reverse the string using unix?
table actions available in oracle connector?
How the ipc stage work?
Define ds designer?