at source level i have 40 columns,i want only 20 cols at
target what r the various ways to get it
Answer Posted / ram
In the transform stage u select wich coloums u want those
coloums only drage from input link to output link.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Which algorithm you used for your hashfile?
How to reverse the string using unix?
How to implement complex jobs in data stage?
What is the difference between informatica and datastage?
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?
What are the differences between datastage and informatica?
How to perform incremental load in datastage?
what is the use of skid in reporting?
Define repository tables in datastage?
What is the purpose of pivot stage?
How many types of sorting methods are available in datastage?
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)
What are the stages in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?