Interested to Buy Any Domain ? << Click Here >> for more details...
if 3 table having different columes. like first table
having 4 columns , second table having 3 columns and third
table having 2 columns then how to capture the data by
using funnel stage in parallel jobs...srinu.thadi
- 17 Answers
- 42751 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / madhusudhan
If you want combine 3tables with different column name.
First use modify stage between source and funnel stage.
change the cloumns name in the 3tables into standard format.
or
you can try with transformer for creating new column name
for each table.
mailme if you have queries.
samala.madhu@gmail.com
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of interprocessor stage in server jobs?
How many types of sorting methods are available in datastage?
Difference between server jobs & parallel jobs?
What are the partitioning techniques available in link partitioner?
in oracle target stage when we use load option and when we use upsert option?
Can we use target hash file as a lookup ?
Explain the situation where you have applied SCD in your project?
Define repository tables in datastage?
root tree will find which is server job and which is parallel job?
How a routine is called in datastage job?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Difference between in process and inter process?
What is the difference between an operational datastage and a data warehouse?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Describe the main features of datastage?
