Interested to Buy Any Domain ? << Click Here >> for more details...
table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
- 9 Answers
- 15225 Views
- I also Faced
- E-Mail Answers
Answer Posted / venky
u can generate sequece generator for both the tables and u
can use joiner transforation,u can get 10 columns
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
options available in sequence job to run,validate?
What is the difference between datastage and informatica?
State the difference between an operational datastage and a data warehouse?
how many rows sorted in sort stage by default in server jobs
what is flow of project?
how to export or import the jobs in .ISX file
What are the partitioning techniques available in link partitioner?
Difference between server jobs & parallel jobs?
What is aggtorec restructure operator?
how to delete one row in target dataset
What is the use of datastage designer?
Distinguish between informatica & datastage. Which one would you choose and why?
If you want to use the same piece of code in different jobs, how will you achieve it?
Give an idea of system variables.
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.
