source contains 2 columns comes to target 4 columns how

Answer Posted / fayaz

by using copyfile we can easily create 4 columns in targetfile.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain engine tier in information server?

644


What are the steps needed to create a simple basic datastage job?

646


how do u catch bad rows from OCI stage? And what CLI stands for?

2275


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1608


what is the use of materialized view?

952






Explain the situation where you have applied SCD in your project?

1552


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1747


What is the difference between odbc and drs stage?

631


Which commands are used to import and export the datastage jobs?

974


what is the use of skid in reporting?

1947


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?

1743


What are the important features of datastage?

606


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

2264


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

510


how to add a new records into source?

1516