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
- 44046 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 all are the different way to run a job?
What is aggtorec restructure operator?
CHANGE CAPTURE
Difference between data warehousing and olap?
Define Data Stage?
How do y read Sequential file from job control?
Explain datastage architecture?
Name the different sorting methods in datastage.
Whats difference betweeen operational data stage (ods) and data warehouse?
What is merge stage?
What steps should be taken to improve Datastage jobs?
How rejected rows are managed in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How do you reject records in a transformer?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
