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
- 43440 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 use of datastage director?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is ibm datastage?
What is oci?
What is the difference between informatica and datastage?
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
On which Dimension Table you implemented SCD Type in your Project
Demonstrate experience in maintaining quality process standards?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Explain usage analysis in datastage?
how many rows sorted in sort stage by default in server jobs
What are the types of jobs we have in datastage?
What is size of a transaction and an array means in a datastage?
How a routine is called in datastage job?
What are the components of datastage?
